>>Hi,
>>
>>Here is a pseudo SQL Select statement:
>>
>>

>>select field1, field2, ... from Table1 left join Table2 on Table1.fieldX = Table2.fieldX where (Long Expression)
>>

>>
>>From running this type of SQL Select and analyzing results, it seems to me that VFP will first do the LEFT JOIN and then apply the WHERE condition to the resulting query. Is this correct?
>>
>>My question is, how do you make the SQL Select to select records from Table1 based on the Long Expression and then LEFT JOIN the resulting query?
>
>Add any conditions from the long expression that involve fields of Table2 to the ON clause.
>
>

>SELECT field1, field2, ... ;
>  FROM Table1 ;
>    JOIN Table2 ;
>      ON Table1.FieldX = Table2.FieldX ;
>       AND Table2.FieldY > Something ;
>  WHERE Table1.FieldZ = SomethingElse
>

>
>Tamar

You see, the problem is that my Long Expression actually has a SUBQUERY (like WHERE IN (Select ....)) and when I move the subquery into the JOIN expression, I get error that this type of syntax is not supported.

Thank you for your suggestion.