Hi there, Anyone knows if is possible to make a Select command between 2 tables located in differents computers.. I wanna only one statament I mean.. I have the host named A, database dbA and table tbl_A... and I have the host named D, databse dbB and table tbl_B...
I would like to write a comand like that: Select * from dbA.tbl_A, dbB.tbl_B where dbA.tbl_A.field=dbB.tbl_B.field thanks a lot
MySQL client connections are specific to a single server, so you cannot do this. A workaround is to open connections to both servers within a program and simulate the join.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
