I'm trying to make an outer join between three tables like these:

-->Table1 :
ID
1
2
3

-->Table2:
ID VAL
1 v1
4 v2

-->Table3:
ID Val
2 v3
3 v4

My issue is that these two queries don't give the same result ! Why ?

--> First query :

SELECT Table1.ID,Table2.Val,Table3.val
FROM Table1
LEFT OUTER JOIN Table2 ON Table2.ID=Table1.ID
LEFT OUTER JOIN Table3 ON Table3.ID=Table1.ID

--> Second query:
SELECT Table1.ID,Table2.Val,Table3.val
FROM Table1
LEFT OUTER JOIN Table3 ON Table3.ID=Table1.ID
LEFT OUTER JOIN Table2 ON Table2.ID=Table1.ID

(the two outer join lines where exchanged).

Under MS Access, these two queries give the same result. Are there any
differences of that
kind between Access and LocalSQL? How can i solve my problem ????

Thanks

P.Vitoux (serv...@d2m.fr)