Need help on Outer Joins

[mmt4331]

Got a question here...Is it possible to use an outer join on three tables. I'm trying to do this w/ the following statements in Access 97, but it won't work:

SELECT *
FROM Customer A Left Join Orders B On (A.[Customer Id] = B.[Customer Id]) Left Join [Orders Detail] C
ON (B.[Order ID] = C.[Order ID]);

BigFuzzyDog

 

[TTThio]

Yes it is possible to do join on 3 or even more tables.
However, when you join them, it will have to show which one is joined first. In your case for example,

SELECT *
FROM [red]([/color]TableA Left Join TableB On TableA.[Customer Id] = TableB.[Customer Id][red])[/color] Left Join TableC
ON TableB.[Order ID] = TableC.[Order ID]);

That way, it recognizes that TableA and TableB are joined first, then the query is joined with TableC.

Hope it help!

Tin Tin