Steve,

What I really need to a way to have over 10 tables joined, from Syntax 1, but be able to use the JOIN features of Syntax 2.

Is this possible?

TIA

Rex

>>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,