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 bo
Hello,
Have you taken a look at the FEDERATED storage engine?
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
It is a storage engine that accesses data in tables of remote databases
rather than in local tables.
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
-O
