[thelist] table join for 4 tables

[Brian Cummiskey]

Max Schwanekamp wrote:
> 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?
> 

doh!

I got my Mords Wixed :p