title: How to INTERSECT in MS Access?
body: <p>Somehow MS Access doesn't seem to have access to the keyword INTERSECT, which I need right now in order to fix some data errors in my database.</p>
  
  <p>I had a look on older questions and found some answers that tried to solve this problem by using a select distinct [...] inner join [...] construction.</p>
  
  <p>However, this doesn't seem to help me, as the syntax doesn't apply to the table I need to intersect.</p>
  
  <p>Here's a short explanation on what I want to achieve with the INTERSECT:</p>
  
  <p>My table looks like this (simplified):</p>
  
  <p>A | B</p>
  
  <p>hello | world</p>
  
  <p>world | hello</p>
  
  <p>Now these datasets are redundant, but unfortunately can't be caught by a constraint, as they are not exactly the same, but mirrored. That's why they got inserted in the first place...</p>
  
  <p>I think normally I would be able to select all the affected data sets by using a </p>
  
  <pre><code> SELECT A,B FROM tbl
   INTERSECT
   SELECT B,A from tbl
  </code></pre>
  
  <p>After having selected them I could just delete them and would be rid of that problem... Does anyone have an idea on how to implement this using MS Access?</p>