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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Markwick Sent: Friday, May 09, 2008 6:00 PM To: [email protected] 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 [Non-text portions of this message have been removed]
