From: A Z
Date: April 15 2004 11:31am
Subject: Query 2 DBs
List-Archive: http://lists.mysql.com/mysql/163704
Message-Id: <20040415113136.79413.qmail@web60302.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit


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.

regards



	
	
		
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html