If the current database is database1 or database2, you can dispense with some of the qualifiers. : Database Join « Join « SQL / MySQL






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

If the current database is database1 or database2, you can dispense with some of the qualifiers.

      

SELECT table1.column1, database2.table2.column2 FROM table1, database2.table2;

Related examples in the same category

1.if the current database is database2, no database2 qualifiers are necessary
2.Qualify the table name with database name
3.Qualify the column name with table name and database name