Can I join two MySQL table stores on separate machines?

Question

I have a relatively easy query that needs information from a local MySQL table along with another MySQL table, which is stored on a physically separate machine (on the same network). I try not to configure replication just to facilitate this easy request, which is only required once a day.

Is there a way I can join a table on a remote machine using a single query? Or run SELECT INTO in a local table.

---

Notes

• I am using C # and .NET 4.

Answer 1

, FEDERATED . .