Mahmoud Badreddine <[EMAIL PROTECTED]> wrote on 05/03/2005 01:43:55 PM:
> 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 As long as the databases are on the same server and the account you logged into mysql with has the appropriate permissions, your statement should work. What happens when you try it? Shawn Green Database Administrator Unimin Corporation - Spruce Pine