Home » MSAccess

Archiv der Kategorie: MSAccess

MS Access – Not in Query

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];