0

Is it possible to write join query between multiple databases across different servers?

Is it possible?

Siddharth Thevaril
  • 3,722
  • 3
  • 35
  • 71
raghu
  • 11
  • 3
    if you have to join multiple tables that are across different databases *AND* servers then you need to really rethink the design. – Memor-X Oct 19 '16 at 05:25

1 Answers1

1

The answer to your question is, Yes it is possible.

But since you have not specified any particular situation you are facing,it is not possible to give a direct answer.

In MySQL it can be done using The FEDERATED Storage Engine.

However I suggest you go through following SO questions

  1. Join tables from two different server
  2. Joining tables across multiple servers
  3. MySQL Cross Server Select Query
  4. MySQL — join between tables in 2 different databases?
  5. How To Left Join 2 Tables On 2 Different Databases?
  6. Connecting multiple database and join query across database in php
Community
  • 1
  • 1
RanjanaLK
  • 685
  • 2
  • 13
  • 26