5

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?

Cratylus
  • 52,998
  • 69
  • 209
  • 339
  • 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
  • Does this answer your question? [Join tables from two different server](https://stackoverflow.com/questions/11114197/join-tables-from-two-different-server) – Nico Haase May 26 '23 at 08:56

1 Answers1

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.

The site shows a good illustration

Dinup Kandel
  • 2,457
  • 4
  • 21
  • 38