In Oracle würde man schreiben:
select feldA from Table1 where feldA not in (select feldB from Table2);
Pendent in MS Access:
SELECT feldA FROM Table1 LEFT JOIN Table2 ON Table1.[feldA]=Table2.[feldB];
In Oracle würde man schreiben:
select feldA from Table1 where feldA not in (select feldB from Table2);
Pendent in MS Access:
SELECT feldA FROM Table1 LEFT JOIN Table2 ON Table1.[feldA]=Table2.[feldB];