title: MS Access: WHERE-EXISTS-clause not working on views?
body: <p>Prerequisites: In MS Access 2010 create the following tables:</p>
  
  <pre><code>CREATE TABLE ATBL(ID INT);
  INSERT INTO ATBL(ID) VALUES (1);
  INSERT INTO ATBL(ID) VALUES (2);
  INSERT INTO ATBL(ID) VALUES (3);
  
  CREATE TABLE BTBL(ID INT);
  INSERT INTO BTBL(ID) VALUES (1);
  INSERT INTO BTBL(ID) VALUES (2);
  </code></pre>
  
  <p>Also create a view called BVIEW which uses the following SELECT statement:</p>
  
  <pre><code>SELECT A.ID FROM ATBL AS A WHERE A.ID = 1 OR A.ID = 2
  </code></pre>
  
  <p>Now BVIEW should have the same contents as BTBL. Nevertheless the following two queries will return different results:</p>
  
  <pre><code>SELECT A.ID FROM ATBL AS A WHERE EXISTS (SELECT 1 FROM  BTBL AS B WHERE B.ID=A.ID)
  SELECT A.ID FROM ATBL AS A WHERE EXISTS (SELECT 1 FROM BVIEW AS B WHERE B.ID=A.ID)
  </code></pre>
  
  <p>The first query returns two records (1 and 2), but the second query returns all records from ATBL. What's wrong here? Am I missing something?</p>