From: Martijn Tonies
Date: April 15 2004 11:49am
Subject: Re: Query 2 DBs
List-Archive: http://lists.mysql.com/mysql/163706
Message-Id: <02ee01c422df$b10d5970$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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.

As far as I know, you cannot.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com