[thelist] table join for 4 tables

Peter Brunone (EasyListBox.com) peter at easylistbox.com
Thu Nov 3 12:09:26 CST 2005


If they're all inner joins, how about just saying

SELECT table1.status, table2.field1, table2.field3, etc.
WHERE table1.status = 10
AND table1.Personid = table2.Personid
AND table1.shippingid = table3.shipppingid
etc.

----------------------------------------
 From: Unsupported Browser <unsupportedbrowser at gmail.com>
Sent: Thursday, November 03, 2005 10:57 AM
To: thelist at lists.evolt.org
Subject: [thelist] table join for 4 tables 

I'm pretty decent with single tables and even double tables, but I have one
query that has to join 4 tables and I am lost. here is the basic gist.
I need to look up information where table1 has a status of 10 and then I
need to get the personid from table1 and pull in the personal information
from table2, using the shippingid from table1 I need to get the address
(about 6 fields) associated with that from table3, then I need to get the
sku information from table4 using the skuid from table1.




More information about the thelist mailing list