Join MySQL

  1. Home
  2. MySQL
  3. Join
  4. If the current database is database2, no database2 qualifiers are necessary
SELECT database1.table1.item, tie.item FROM db1.shirt, tie;