Mega Code Archive

 

Categories / MySQL / 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;