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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
