select db1.table.field, db2.table.field where db1.table.someotherfield = db2.table.someotherfield
Peter > -----Original Message----- > From: Ed Reed [mailto:[EMAIL PROTECTED] > Sent: 24 March 2004 23:45 > To: [EMAIL PROTECTED] > Subject: Query across two databases on the same server > > > Is there any way to have a single select statement that can do a join > across two databases on the same server? > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]