I believe, yes, it is possible. However it may depend on the specific john conditions you need. Perhaps you can do it without unsertaincies in two-three steps preparing intermediate cursors to get the final cursor.

Also you can use the Query/View designer, that suppose to do the 'dirty' code work for you. See "Querying Multiple Tables and Views" in VFP6 Help for more details.

>Yuri,
>
>What I really need is to use Syntax 2 for LEFT and RIGHT JOINs, but be able to join over 10 tables from Syntax 1.
>
>Is this possible?
>
>TIA
>
>Rex
>
>>In some cases you can use UNION to achieve result similar to JOHN.
>>
>>>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 ;
>>>    FROM ;
>>>      Table1 ;
>>>    INNER JOIN Table2 ;
>>>      ON Table1.Field1 = Table2.Field2 ;
>>>    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