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]

Reply via email to