you'll need to create temporary tables in one of the servers based on the results of the other and then join.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 17, 2004 2:54 PM Subject: Query to another server Is it possible to query one server from another even if those servers are in diferent machines at diferent locations? for example: select * from localtable left join remoteserver.remotedatabase.remotetable where localtable.key = remoteserver.remotedatabase.remotetable.key FBR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
