Assuming you have the proper permissions (which could get confusing), I suppose it could be done. So, I'll follow up with one of my most frequent responses: why don't you try it and then let us know?
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Fabio Bernardo" <[EMAIL PROTECTED]> To: "Mysql (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 15:08 Subject: Select between different hosts 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
