if the current database is database2, no database2 qualifiers are necessary : Database Join « Join « SQL / MySQL






  1. SQL / MySQL
  2. Join
  3. Database Join

if the current database is database2, no database2 qualifiers are necessary

      


SELECT database1.table1.item, tie.item FROM db1.shirt, tie;

Related examples in the same category

1.If the current database is database1 or database2, you can dispense with some of the qualifiers.
2.Qualify the table name with database name
3.Qualify the column name with table name and database name