MySQL Forums
Forum List  »  General

Is there a way to search two databases as one
Posted by: Steve Williams
Date: April 14, 2005 11:37AM

I want to search TWO separate databases with one MYSQL QUERY as if they where the same table. Both contain the same tables and structure. Is there a way to do this and what are the minimum MYSQL requirements...

I am currently trying:
SELECT * FROM DB1.table,DB2.table;

HOWEVER I ONLY GET RESULTS FROM THE LAST DATABASE TABLE SPECIFIED... It seems it is just ignoring the first DATABASE specified.

I am currently running MYSQL version: 4.1.10a

Any help is appreciated.

Thanks,

Options: ReplyQuote


Subject
Written By
Posted
Is there a way to search two databases as one
April 14, 2005 11:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.