<> not working for the SQL statement

[NikhilSandavekarCP]

i am trying to extract order which doesnt have rejection code which are '62' and 'CC'

i tried using the same in SQL statement but not able to get the filtered data 

Below is my code : 

[/BIC/ACS_NA_C2_1]:
LOAD
[SALESORG] as [Sales Org],
[/BIC/ORD_IT_QT] as [Order-Item Qty],
[DLV_QTY] as [Delivery Qty],
[/BIC/ZCALMNTHG] as [Calendar Month],
[/BIC/ZCALYEARG] as [Calendar Year];

SQL Select SALESORG,/BIC/ORD_IT_QT, DLV_QTY, /BIC/ZCALMNTHG, /BIC/ZCALYEARG from /BIC/ACS_NA_C2 WHERE SALESORG = 'US01' and /BIC/ZCALMNTHG = '$(CurrMonth)' and /BIC/ZCALYEARG = '$(CurrYear)' and /BIC/ABGRU <> 'CC' or /BIC/ABGRU <> '62';

[Taoufiq_Zarra]

@NikhilSandavekarCP  have you tested ?

and ( /BIC/ABGRU <> 'CC' or /BIC/ABGRU <> '62')

[NikhilSandavekarCP]

Hello Taoufiq,

I tried the same before but didnt work for me

[Taoufiq_Zarra · Accepted solution]

@NikhilSandavekarCP  and ?

[/BIC/ACS_NA_C2_1]:
LOAD
[SALESORG] as [Sales Org],
[/BIC/ORD_IT_QT] as [Order-Item Qty],
[DLV_QTY] as [Delivery Qty],
[/BIC/ZCALMNTHG] as [Calendar Month],
[/BIC/ZCALYEARG] as [Calendar Year],
[/BIC/ABGRU]

where Match([/BIC/ABGRU],'CC','62')=0;

SQL Select SALESORG,/BIC/ABGRU,/BIC/ORD_IT_QT, DLV_QTY, /BIC/ZCALMNTHG, /BIC/ZCALYEARG from /BIC/ACS_NA_C2 WHERE SALESORG = 'US01' and /BIC/ZCALMNTHG = '$(CurrMonth)' and /BIC/ZCALYEARG = '$(CurrYear)';

[NikhilSandavekarCP]

Thanks a lot that worked like a Charm!!!

[MayilVahanan]

HI @NikhilSandavekarCP 

Try with not in

 /BIC/ABGRU not in ('CC','62');