ONE QUERY - 4 DATABASE AT ONCE?

[aleczapka]

Hi all..

Does any1 know how to query a few databases with one query?

How to get data out of the, lets say, 5 databases, with one query?

TIA

[georgen]

select * from database1.table, database2.table, database3.tabe, database4.table;

[Anon]

SELECT a.fieldone, b.otherfield FROM databaseOne.tableOne a, databaseTwo.tableTwo b;

etc...

You can JOIN different databases like this, too.