Re: Query to another server

[Chris Nolan]

You might be able to cheat and replicate the required database to the 
local machine.

Regards,

Chris

Terence wrote:

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]