title: Access- Where and OR not working
body: <p>I have the following query written in MS Access</p>
  
  <pre><code>SELECT DISTINCT Table1.ColumnA, Table1.ColumnB,Table1.ColumnC,Table1.ColumnD,Table1.ColumnE
  FROM Table2 
  RIGHT JOIN Table1 ON (Table2.ColumnB = Table1.ColumnF) 
  WHERE (Table1.ColumnF &lt;&gt;28) OR (Table1.ColumnF&lt;&gt;29)
  </code></pre>
  
  <ol>
  <li>Tried to with and without Parentheses </li>
  <li>When I just have one where statement the 262 records go down to 160 records, as expected</li>
  <li>When I have the two conditions connected by the OR, the records go back up to 262, clearly not doing whats expected. Even if just the first condition held, I should not have gone back up to 262 records.  </li>
  </ol>
  
  <p>My question is whats wrong with my query, especially as it pertains to the WHERE XXX OR XXX?  </p>
  
  <p>Secondly, does the RIGHT JOIN statement have any bearing on the outcome of a subsequent WHERE statement.  </p>
  
  <p>Thirdly, if I cannot combined a RIGHT JOIN and a WHERE, what is the optimal way to apply conditions to a query that relies on a RIGHT JOIN?</p>
  
  <p>Appreciate any help! </p>