tsql - SQL 查询组合过滤两个字段

Question

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

我想过滤包含( company = 12 和 storage = 1 )和( company = 2 和 storage = 1 )的行，也将过滤掉结果集 articlenr 。

这就是我想出的，但确定必须有一种更简单的方法来进行查询吗？

SELECT  * FROM    MyTable 
where 
    (Company=2 and Storage<>1 and ArticleNumber='01-01227') 
or 
    (Company=12   and Storage<>1 and ArticleNumber='01-01227') 
or
    (Company<>2 and Company<>12 and ArticleNumber='01-01227') 

我追求的结果:

ArticleNumber   Company Storage
  01-01227      12      2
  01-01227      5       1

Answer 1

SELECT * FROM MyTable
WHERE ArticleNumber='01-01227'
AND (Company NOT IN (2,12) OR Storage <> 1)