Db2 – SQL db2 remove specific item from the query

db2excel

Can you please help me out with the below query?
What I am looking for is a code to exclude items with wording '90003' from column COR_ID.
So far I have a code that extracts data with date older than today from column VAL_DT, excluding items with wordings MAN, NOSTRO, SCREV and SCRIN for which query shows also dates newer than today.

All I need is for the below code is to remove '90003' from column COR_ID

WHERE 
    VAL_DT < CURRENT DATE AND COR_ID <> '90003'
    OR (   
       MVT_DS = 'NOSTRO' 
       OR MVT_DS = 'SCREV' 
       OR MVT_DS = 'SCRIN'
       OR MVT_DS = 'MAN' 
       )    

Best Answer

Following WHERE clause shold do the job

WHERE COR_ID <> '90003'
  AND (VAL_DT < CURRENT DATE  OR MVT_DS in ('NOSTRO', 'SCREV', 'SCRIN', 'MAN')  )