[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