[thelist] table join for 4 tables

Max Schwanekamp lists at neptunewebworks.com
Thu Nov 3 13:24:14 CST 2005


Brian Cummiskey wrote:
> select YOURFIELDS.table1, YOURFIELDS.table2, YOURFIELDS.table3, 
> YOURFIELDS.table4  from table1
> left outer join table2 on table1.personid = table2.personid
> left outer join table3 on table1.shippingid = table3.shippingid
> left outer join table 4 on table1.skuid = table4.skuid
> where table1.status = '10'

Isn't that supposed to be table1.YOURFIELDS, table2.YOURFIELDS, etc?

-- 
Max Schwanekamp
http://www.neptunewebworks.com/




More information about the thelist mailing list