title: Select rows not matching a specified value (multi entries)
body: <p>I have a table with images like</p>
  
  <pre><code>imageID  imageName
  12223    my nice image #1 
  12224    my nice image #2
  12225    my nice image #3
  </code></pre>
  
  <p>a table with categories</p>
  
  <pre><code>categoryID  categoryName
  110         animals 
  111         cars 
  112         food 
  </code></pre>
  
  <p>and a table image_to_category with</p>
  
  <pre><code>imageID  categoryID
  12223    110
  12223    111
  12224    110
  12225    112
  </code></pre>
  
  <p>i now want to select all images which are <strong>NOT</strong> in category 110. Technically this is only possible in the where clause of a much more complex query. So my first intention was to use</p>
  
  <p><code>... WHERE imageID IN (SELECT imageID FROM _image_to_category WHERE categoryID NOT IN (110))</code></p>
  
  <p>but this only works if the image has 110 as the only category. If the image is in two different categories it wont obviously work.</p>
  
  <p>Is it possible to group the select in the where clause?
  Or any other ideas?</p>
  
  <p>thx.</p>