From: Ed Carp
Date: March 21 1999 2:00am
Subject: Re: How to link tables in different databases
List-Archive: http://lists.mysql.com/mysql/703
Message-Id: <007f01be733e$a975f880$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

> I need to link on a single query two tables in different databases. I have
done it on Access linking external
> tables into actual database (external link).


Not sure I understand what you mean.  Do you mean doing something like
"select * from table1, table2 where table1.id=table2" and table1 is in
database1 and table2 is in database2?  If so, "select * from
database1.table1, database2.table2 ... " should do what you want to do.

Also getting a good book on SQL would really, really help.