db2 Where not in multiple columns Filter out multiple combinations of values
Example
Lets say you want to filter a query by two columns, but only certain combinations of those columns. For example, it's OK to have account 60400 with reference JE, but you cannot have account 60400 with reference ED, but you can have account 60500 with reference ED.
select * from schema.table where (acct, ref) not in
( values
(60400, 'ED'),
(60600, 'ED'),
(60701, 'ED'),
(70400, 'ED'),
(70500, 'ED'),
(70600, 'ED'),
(80800, 'ED')
);
