I found the problem. There was a hyphen in my database name. Re-created the database and re-imported my data, now everything works fine. Thanks to everyone. >>> Egor Egorov <[EMAIL PROTECTED]> 3/25/04 8:19:04 AM >>> "Ed Reed" < [EMAIL PROTECTED] > wrote: > > yea, I thought it would be that easy too but it doesn't work.
It should work. Did you get error message? > > 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? >> -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]