MySQL ODBC Connector - Joining data from two databases

Author

Joining data from two databases

Anthony Brown

2005-09-27, 8:24 pm

Hi,

I have one database that I would like to split into two..
Well actually my client does.. I don't think we should.

But, is there a way to join data from the seperated databases?

One table authors will be connected to a table called contacts each residing
in different databases on the same server.

Thanks for any help
:Ant

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.8/113 - Release Date: 9/27/2005

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Jasper Bryant-Greene

2005-09-27, 8:24 pm

Anthony Brown wrote:
> I have one database that I would like to split into two..
> Well actually my client does.. I don't think we should.
>
> But, is there a way to join data from the seperated databases?
>
> One table authors will be connected to a table called contacts each residing
> in different databases on the same server.

SELECT ...
FROM db1.table1
LEFT JOIN db2.table2
WHERE ...

?
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links