From: Juan Riera
Date: March 21 1999 11:37pm
Subject: RE: How to link tables in different databases
List-Archive: http://lists.mysql.com/mysql/749
Message-Id: <001301be73f3$d6ea9ea0$0100a8c0@p233.mygroup>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


>
>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.


OK - this is my question well formulated! Thanks.


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

Maybe you could reccomend one?

Regards,
Juan