title: SQL for finding types that have all ids on some row
body: <p>I am working with SQL queries in ACCESS 2010 and I have a table that looks something like this:</p>
  
  <pre><code>Mytable
  ID  |  TYPE
  1   |  a
  1   |  b
  2   |  a
  2   |  a
  3   |  a
  3   |  b
  3   |  c
  </code></pre>
  
  <p>And I want to return all types that matches with every ID at least once.
  So in this case only <code>a</code> will be return since its the only type represented on a row with <code>1</code>,<code>2</code> and <code>3</code>. </p>
  
  <p>Help greatly appreciated!</p>