>Hi,
>
>This is a very newbie question, I know.
>
>I am trying to understand the SQL Select that Tamar Granor kindly helped me with. It has two JOIN clauses. And THEN, after the second JOIN, there are two ON clauses. I didn't know you can do it. I thought that ON should follow the JOIN immediately.
>And looks like the first ON belong to the top (first) JOIN and the second ON belongs to the bottom (second) JOIN.
>
>My question is, how does SQL Server (or VFP for that matter) knows which ON apply to which JOIN?
>
>TIA

For all I know, there is the following syntax:

Syntax one: The ON follows the JOIN, from top to bottom

SELECT * ;
FROM Cur1 ;                     && - 
 INNER JOIN Cur2 ;              && - First Join	&& -
  ON Cur1.Field=Cur2.Field ;    && +            && |
 ;                                              && | Second Join (this is: to the result of the first)
 INNER JOIN Cur3 ;                              && -        && -
  ON Cur2.Field=Cur3.Field                      && +        && | ....

Syntax two: The ONs follows the JOINs, inside to outside

SELECT *;
 FROM Cur1;                                         && -
  INNER JOIN Cur2;              && -                && -
  INNER JOIN Cur3;              && - First Join     && |
  ON Cur2.Field=Cur3.Field;     && +                && | Second Join (this is: to the result of the first)
 ON Cur1.Field=Cur2.Field                           && +

You are free to mix the styles. It might create a headache, but is it possible.

Update: tab to space