>>There're at least 3 ways you can do that
>>
>>* 1 - EXISTS subquery
>>SELECT * FROM mytable1 WHERE NOT EXISTS (SELECT 1 FROM mytable2 WHERE myfield1 = mytable1.myfield1)
>>* 2 - JOIN
>>SELECT mytable1.* FROM mytable1 LEFT JOIN mytable2 ON mytable2.myfield1 = mytable1.myfield1 ;
>> WHERE mytable2.myfield1 IS NULL
>>* 3 - IN subquery
>>SELECT * FROM mytable1 WHERE myfield1 NOT IN (SELECT myfield1 FROM mytable2)
>>
>>The second one most likely will be the fastest in VFP
>>
>
>
>Shouldn't #2 be a left join ?
Yes, it should be
--sb--