7 messages in com.mysql.lists.win32RE: Link databases
FromSent OnAttachments
Joris Lambrecht06 Mar 2001 08:47 
René Tegel06 Mar 2001 10:38 
Gerald Jensen06 Mar 2001 13:52 
Robert Adams06 Mar 2001 18:49 
PeterWR07 Mar 2001 03:24 
Luc Van der Veken08 Mar 2001 01:28 
Rob Eyre08 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 ?