>>This is the minimal example that show the difference
>>

>>CREATE CURSOR x (a i,e i)
>>CREATE CURSOR y (b i,f I)
>>
>>INSERT INTO x VALUES ( 1,2 )
>>INSERT INTO x VALUES ( 2,3 )
>>
>>INSERT INTO y VALUES ( 1,1 )
>>
>>SomethingCondition = "Y.f IS NULL"
>>SELECT * FROM X LEFT JOIN Y ON X.a = Y.b WHERE &SomethingCondition
>>
>>SELECT * FROM X LEFT JOIN Y ON X.a = Y.b AND &SomethingCondition
>>
>>SELECT * FROM X JOIN Y ON X.a = Y.b AND &SomethingCondition
>>

>
>That's a really ambiguous question to ask. That is, I'm not sure what result you want in that case.
>
>Tamar

You asked for the example in your previous response - you got it :)