title: Using WHERE NOT EXISTS in MS Access SQL Query
body: <p>I have a query that matches a field from a query to another field from a table.  Here is the query:</p>
  
  <pre><code>SELECT DISTINCT CarriersToSend.Carrier, [Dual Year Carrier Report].TPA_CARRIER
  FROM [Dual Year Carrier Report] INNER JOIN CarriersToSend ON [Dual Year Carrier Report].TPA_CARRIER = CarriersToSend.Carrier;
  </code></pre>
  
  <p>It returns the values that match in the Carrier field of the CarriersToSend query and the TPA_CARRIER field of [Dual Year Carrier Report].  </p>
  
  <p>I then need to return the values that are in the Carrier field of the CarriersToSend query that do not appear in the above query.  I think it would be something like a WHERE NOT EXISTS QUERY.  I put one together below, but it is not returning anything and I cant figure out why.  Any help would be much appreciated.  Thank you!</p>
  
  <pre><code>SELECT DISTINCT EE_First, EE_LAST
  FROM [Dual Year Carrier Report]
  WHERE NOT EXISTS (
  SELECT DISTINCT CarriersToSend.Carrier, [Dual Year Carrier Report].TPA_CARRIER
  FROM [Dual Year Carrier Report] INNER JOIN CarriersToSend ON [Dual Year Carrier Report].TPA_CARRIER = CarriersToSend.Carrier;)
  </code></pre>