title: MS Access - WHERE IN works, but WHERE NOT IN fails
body: <p>I have the following query (simplified) on MS Access:</p>
  
  <pre><code>SELECT * FROM table1 WHERE table1.ID NOT IN (SELECT DISTINCT table1id FROM table2);
  </code></pre>
  
  <p>My problem is it doesn't work, but these two ones work:</p>
  
  <pre><code>SELECT * FROM table1 WHERE table1.ID IN (SELECT DISTINCT table1id FROM table2);
  SELECT * FROM table1 WHERE table1.ID NOT IN (2, 3);
  </code></pre>
  
  <p>The first one simply returns me an empty set, while I know I have records on <code>table1</code> with ids ranging from 1 to 9, and only 2 and 3 are use on table 2.</p>
  
  <p>Any help?</p>