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