Re: How to link table from two databse?

[Mike Hillyer]

Are they two databases on the same mysql instance? Two instances? Separate physical servers?

If same instance just do SELECT ... FROM databaseA.tableB, databaseB.tableA ...;

Otherwise look at federated tables in MySQL 5: http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]
Mobile: [phone]
Blog: http://www.openwin.org/mike