Fields that have no Access sql Access

1

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));
    
asked by Rubén Polo 16.05.2016 в 13:15
source

0 answers