I guess we can do database1.table1 join database2.table2 on etc. I.e. join tables in separate databases on the same server.
Is it possible to join tables across different sql servers?
Asked
Active
Viewed 4,407 times
5
Cratylus
- 51,496
- 63
- 200
- 333
-
Possible duplicate http://stackoverflow.com/questions/5698378/mysql-join-between-tables-in-2-different-databases – KaeL Jun 24 '13 at 06:25
-
It is possible with multiple connections. – Mark Jun 24 '13 at 06:25
1 Answers
3
you can use FEDERATED Storage Engine.
The FEDERATED storage engine lets you access data from a remote
MySQL database without using replication or cluster technology.
Querying a local FEDERATED table automatically pulls the data
from the remote (federated) tables. No data is stored on the local tables.
Dinup Kandel
- 2,449
- 4
- 20
- 37