yea, I thought it would be that easy too but it doesn't work. Any other ideas?
>>> "Peter Lovatt" <[EMAIL PROTECTED]> 3/24/04 3:53:03 PM >>> 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]
