Thanks I'll give this a try.
Charlie -----Original Message----- From: php_mysql@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Muthukumar Selvarasu Sent: 09 May 2008 10:21 To: php_mysql@yahoogroups.com Subject: RE: [php_mysql] Joins with two MySQL Databases Hi Yes Try this way Select db1.table.field, db2.table.field from db1.table , db2.table Thanks & regards, Muthukumar Selvarasu, Project Manager (Web Development), Webmasters Ltd. From: php_mysql@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Markwick Sent: Friday, May 09, 2008 6:00 PM To: php_mysql@yahoogroups.com Subject: [php_mysql] Joins with two MySQL Databases Is it possible to join tables from two different MySQL servers? eg:- MySQL server @ 217.10.222.57 with Database DB1 MySQL server @ 210.127.2.23 with Database DB2 Joining table DB1.BlueNames using field BlueID with table DB2.RedNames using field RedID. Charlie
