Is it possible to have one select statement that can join tables from more than one database?
SELECT t1.f1, t2.f2 FROM db1.tbl1 AS t1 LEFT JOIN db2.tbl1 AS t2 ON ...
how would you query it if the databases have different usernames/pws?