[snip] 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. [/snip] You don't say what version of MySQL, but this would be the expected behavior. UNION would be a good start... http://dev.mysql.com/doc/mysql/en/union.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]