JOINing Tables Across MySql Servers

2001-02-18 Thread Jay Habegger
MySql Experts: I have a mysql server running on host A with database X and a mysql server running on host B with database Y. In the context of a select I want to JOIN a table in database X on host A with a table in database Y on host B. Can this be done? Do I have to do anything special with

Re: JOINing Tables Across MySql Servers

2001-02-18 Thread Paul DuBois
On Sun, Feb 18, 2001 at 12:11:09PM -0800, Jay Habegger wrote: MySql Experts: I have a mysql server running on host A with database X and a mysql server running on host B with database Y. In the context of a select I want to JOIN a table in database X on host A with a table in