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'
)