Hi, I would like to run a query on two tables that reside in two distinct databases:
select * from db1.table1 join db2.table2; This lists both tables adjacent to one another rather than in a sequential fashion as one would get if both tables came from the same database. Is there a way to accomplish this task. Thank you. -- -Mahmoud Badreddine
