>>>>* 1 - EXISTS subquery >>>>SELECT * FROM mytable1 WHERE NOT EXISTS (SELECT 1 FROM mytable2 WHERE myfield1 = mytable1.myfield1) >>>>* 2 - JOIN >>>>SELECT mytable1.* FROM mytable1 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