RE: Link databases - Rob Eyre - com.mysql.lists.win32

7 messages in com.mysql.lists.win32RE: Link databases

From	Sent On	Attachments
Joris Lambrecht	06 Mar 2001 08:47
René Tegel	06 Mar 2001 10:38
Gerald Jensen	06 Mar 2001 13:52
Robert Adams	06 Mar 2001 18:49
PeterWR	07 Mar 2001 03:24
Luc Van der Veken	08 Mar 2001 01:28
Rob Eyre	08 Mar 2001 01:31

Subject:	RE: Link databases
From:	Rob Eyre (rob....@oxtrust.org.uk)
Date:	03/08/2001 01:31:34 AM
List:	com.mysql.lists.win32

Peter,

Try

SELECT db1name.tbl1name.fieldname, db2name.tbl2name.fieldname FROM db1name.tbl1name INNER JOIN db2name.tbl2name ON db1name.tbl1name.ID = db2name.tbl2name.ID;

-Rob

Hi,

Is it possible to link seperate databases, so I can JOIN tabels from all databases in the same SELECT ?