If both tables have the same definition and you want to know how to display the data of one of them after the other you need to do a:
select * from db1.table1 union select * from db2.table2;
Andrés Villanueva
Mahmoud Badreddine wrote:
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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
