Doug,

Thanks. Your code is very clear.

For my understanding,

In you code, SQL command will first join the first two tables (TABLE1, TABLE2), then second join the result of first join with the next table (TABLE3), then take second jion result and join it to the next table (TABLE4).
Is this correct?

If I change your code to this as a nested Join.

from TABLE1 ;
join TABLE2 ;join TABLE3 ;
join TABLE4 ;
on TABLE1.FIELD1 = TABLE2.FIELD1 ;
on TABLE2.FIELD2 = TABLE3.FIELD2 ;
on TABLE3.FIELD3 = TABLE4.FIELD3

1. Generally, how the SQL commad deal with nested jion and which Join do first, second and Third?

2. This code(I CHANGED) will get the same result like your original code?


Jim