Joining tables across multiple servers

Question

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?

Answer 1

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