I'm trying to get an sql for Access that takes out the records that have no relation, the key of the references is Type, Anne, Number and the other table, article, has the fields: type, anne, number, dossier I have done this but it does not return values
SELECT *
FROM articleEntreedescom
WHERE not exists(select *
from references_6851
where (articleEntreedescom.Type = references_6851.Type)
AND (articleEntreedescom.nume = references_6851.Numéro)
AND (articleEntreedescom.Anee = references_6851.Année));