title: Access substitute for EXCEPT clause
body: <p>How can I get the same result I would get with the SQL code below in ms access? It does not recognize the <code>EXCEPT</code> clause...</p>
  
  <pre><code>SELECT DISTINCT 
         P.Name, 
         T.Training
    FROM Prof AS P, 
         Training_done AS TC, 
         Trainings AS T
   WHERE (P.Name Like '*' &amp; NameProf &amp; '*') 
     AND (P.Primary_Area = T.Cod_Area)
  EXCEPT
  SELECT DISTINCT 
         P.Name, 
         T.Training
    FROM Prof AS P, 
         Training_done AS TC, 
         Trainings AS T
   WHERE (P.Name Like '*' &amp; NameProf &amp; '*') 
     AND (P.Cod_Prof = TC.Cod_Prof);
  </code></pre>
  
  <p>Thanks in advance!</p>