Hi, 2 DBs sitting on different machines, any idea of how to run the query?
Select a.*, b.field1 from computernam.db1.table1 a, computername.db2.table1 b where a.fieldx = b.fieldx where computername is host for DB. regards ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]