"NOT IN" clause using
Somebody kow why happen if I have a statement which do this:
SELECT * FROM OPDETM
WHERE WAREHOUSE not in ('dd','di','dx')
and then that statements which warehouse code is empty I don't get back from this select.
My question is how can I use this "not in" clause if I would like to see that warehouse also which is empty.
Somebody kow why happen if I have a statement which do this:
SELECT * FROM OPDETM
WHERE WAREHOUSE not in ('dd','di','dx')
and then that statements which warehouse code is empty I don't get back from this select.
My question is how can I use this "not in" clause if I would like to see that warehouse also which is empty.