possible to select from multiple databases?

2006-05-05 Thread Bing Du
Hello, I have two separate databases that I need to query data from. In the following SELECT statement, 'title' and 'db_entry_name' are in database1, and 'projectID' is in database2. If they were in one database, this SELECT should work. How should I tweak it to get data from both database1

RE: possible to select from multiple databases?

2006-05-05 Thread Jimmy Guerrero
-Original Message- From: Bing Du [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 4:09 PM To: mysql@lists.mysql.com Subject: possible to select from multiple databases? Hello, I have two separate databases that I need to query data from. In the following SELECT statement, 'title

Re: possible to select from multiple databases?

2006-05-05 Thread Eric Braswell
Bing Du wrote: I have two separate databases that I need to query data from. In the following SELECT statement, 'title' and 'db_entry_name' are in database1, and 'projectID' is in database2. If they were in one database, this SELECT should work. How should I tweak it to get data from both