title: SQL-query to filter on two fields in combination
body: <pre><code>ArticleNumber   Company Storage
   01-01227       12      2
   01-01227       2       1  'filtered by company/storage in combination
   01-01227       5       1
   01-01227       12      1  'filtered by company/storage in combination
   01-44444       5       4  'filtered by not match the articlenumber
  </code></pre>
  
  <p>I want to filter so rows containing (<code>company = 12</code> <strong>and</strong> <code>storage = 1</code>) and (<code>company = 2</code> <strong>and</strong> <code>storage = 1</code>) will be filtered out of the result set and also filter on <code>articlenr</code>.</p>
  
  <p>This is what I come up with, but sure there must be an easier way to make that query?</p>
  
  <pre><code>SELECT  * FROM    MyTable 
  where 
      (Company=2 and Storage&lt;&gt;1 and ArticleNumber='01-01227') 
  or 
      (Company=12   and Storage&lt;&gt;1 and ArticleNumber='01-01227') 
  or
      (Company&lt;&gt;2 and Company&lt;&gt;12 and ArticleNumber='01-01227') 
  </code></pre>
  
  <p>The result I'm after:</p>
  
  <pre><code>ArticleNumber   Company Storage
    01-01227      12      2
    01-01227      5       1
  </code></pre>