I have many country specific databases with same tables, want to select values from a particular table of all databases.
How to implement join in this scenario?
SELECT column1, column2 FROM db1.table1
SELECT column1, column2 FROM db2.table1
labzus :
You can use UNION :\n\nSELECT column1, column 2 FROM db1.table1 \nUNION\nSELECT column1, column 2 FROM db2.table1\nUNION\nSELECT column1, column 2 FROM db3.table1\n\n\n...",
2016-06-09T08:08:07