title: Select group of rows that match all items in a list
body: <p>Assume I have two tables:</p>
  
  <p><code>cars</code> – list of cars</p>
  
  <pre><code>carname | modelnumber | ...
  </code></pre>
  
  <p><code>passedtest</code> – contains every test that a car passed:</p>
  
  <pre><code>id | carname | testtype | date | ...
  1  | carA    | A        | 2000 |
  2  | carB    | C        | 2000 |
  3  | carC    | D        | 2001 |
  4  | carA    | C        | 2002 |
  </code></pre>
  
  <p>Now, how can I select a car from the <code>passedtest</code> table that passed all tests (A, B, C, D)?</p>
  
  <p>I tried the <code>IN</code> statement but it also matches cars that pass even one test. I am looking for a statement to match <em>all</em> values in a list across all rows.</p>