Mega Code Archive

 

Categories / MySQL / Join

 

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

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