>All,
>
>When creating SQL code in VFP, you can use one of two syntaxes:
>
>

>Syntax 1.:
>   SELECT ;
>      Table1.Field2,;
>      Table2.Field3 ;
>    FROM ;
>      Table1,;
>      Table2 ;
>    WHERE ;
>      Table1.Field1 = Table2.Field2 ;
>    INTO CURSOR SQLType1
>
>Syntax 2.
>   SELECT ;
>      Table1.Field2,;
>      Table2.Field3 ;
>      <b>Table3.Field2 ;</b>
>    FROM ;
>      Table1 ;
>    INNER JOIN Table2 ;
>      ON Table1.Field1 = Table2.Field2 ;
>    <b>JOIN Table3 ;
>      ON table1.field3 = table3.field1 ;</b>
>    INTO CURSOR SQLType1
>
>

>Type 1 allows the user to combine many more tables then Type2, but Type 2 allows the user to easily join tables in various ways (LEFT JOIN, RIGHT JOIN, FULL JOIN etc).
>
>Is there a way to combine the two syntaxes?
>TIA
>
>Rex

Rex,

You can join additional tables with syntax 2. See changes in bold above.

HTH,