Re: SELECT from different databases/servers tables

[pearsojd]

Hi Peter,

If your db is db_1 and the other db on the same engine is db_2;

select table1.attribute1, table2.attribute2
from db_1.table1, db_2.table2
where table1.attribute1 = table2.attribute2;

Obviously you may need to `fully qualify` the statement if you have same table names in both dbs. eg select db1.table1.attribute1, db2.table1.attribute1, etc

That should work assuming you have the appropriate permissons on both db's.

Hope that helps.

James