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/[EMAIL PROTECTED]

Reply via email to