SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql if value is null not equal does not work

user8851230Aug 18 2020 — edited Aug 18 2020

I have the below query, but the AND pd.FROMLOC <> 'DMS' does not work if the column has {null} is there a workaround?

SELECT pd.wavekey, pd.orderkey, o.externorderkey, pd.pickdetailkey, pd.status, pd.fromloc, pd.loc, pd.sku, pd.qty, pd.adddate, SUBSTR(o.c_zip,1,3), O.SUSR4, od.cartonbreak

FROM sprtict.pickdetail pd

Join sprtict.ORDERS O on O.ORDERKEY = PD.ORDERKEY

Join sprtict.ORDERDETAIL OD on OD.ORDERKEY = O.ORDERKEY and od.ORDERLINENUMBER = pd.ORDERLINENUMBER

WHERE(PD.adddate BETWEEN (TRUNC(SYSDATE-1) + 21/24) AND (TRUNC(SYSDATE) + 21/24))

AND od.cartonbreak NOT IN ('FLOORPICK', 'LIFTPICK', 'STRINGERS')

AND pd.FROMLOC <> 'DMS'

AND pd.LOC <> 'DMS'

AND O.SUSR4 = '3P01'

AND pd.wavekey = '0001520762'

AND o.externorderkey = 'SP000044662873'