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