From: Adam Hooper
Date: July 22 2003 5:01pm
Subject: Re: Select between two servers
List-Archive: http://lists.mysql.com/gui-tools/959
Message-Id: <3F1D6DE5.6080904@densi.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

This cannot be done. The closest I can think of is server replication, 
but that's certainly not something that belongs on this mailing list, 
and I'm not the guy to ask ;). I don't even know if it's possible :)

Adam Hooper
adamh@stripped

Tom Achtenberg wrote:
> I have a local MySQL installed and MyODBC connections to two other MySQL databases.  In the command center I can execute sql commands on any one individual database.  What I need to do is select from table on two different servers.  I have not been able to find the syntax for the from in a select that specifies the server the table is in.  Can anyone help?
> 
> 
> Tom Achtenberg
> 
> SQL Programmer/Report Writer
> Food for the Hungry US
> Information Technologies
> (480) 609-7750 
> 
> 
>