[thelist] MS Table Join Question (from Excel)

[Luther, Ron]

The redoubtable RonL. asked such a question:

>>Select a buncha junk 
>>FROM Table_1 AL1, Table_2 AL2, table_3 AL3, Customer AL4 WHERE 
>>(AL1.PART=AL2.Sku AND AL1.Code=AL3.CODE AND AL4.CUSTOMER_NUMBER=AL1.CUSTOMER_NUMBER)  
>>AND (other conditions)

>>The problem is that this AL4 customer reference table may not be complete ... so I need a >>leftjoin/rightjoin on that last bit in the where clause to pull in all records from table AL1 regardless of >>whether they match up in AL4 or not.

>>Can I buy a clue on the syntax?


And found his own answer!  (Well, technically, I cheated and created the answer using a separate gui based reporting technology that allowed me to peek under the skirt and check out the answer!)

Which is ...

Select a buncha junk 
FROM Table_2 AL2, table_3 AL3, Table_1 AL1 LEFT OUTER JOIN Customer AL4 
ON (AL1.CUSTOMER_NUMBER=AL4.CUSTOMER_NUMBER)
WHERE 
(AL1.PART=AL2.Sku AND AL1.Code=AL3.CODE)  
AND (other conditions)

Didn't know about that "on" splifflety goodness.

Sorted!

Cheers,
RonL.