title: SQL SELECT: I need a "IN ALL" Clause
body: <p>I have two tables. And I need all <code>organizer_id</code>s that organized ALL events between 2010 and 2012.</p>
  
  <pre><code>event
  --------- 
  event_id
  name
  year
  
  
  event_organizer
  ---------
  event_id
  organizer_id
  </code></pre>
  
  <p>I tried something like this:</p>
  
  <pre><code>SELECT organizer_id 
    FROM event_organizer
   WHERE event_id IN (SELECT event_id 
                        FROM event 
                       WHERE year&gt;=2010 AND year&lt;=2012);
  </code></pre>
  
  <p>But it didn't work because I need only the <code>organizer_id</code> which have organized ALL events between 2010 and 2012. I have no idea how the query should look like that it works as I want. </p>