"NOT IN" clause Somebody kow why h 1

[Iby]

"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.

 

[sem]

The idea is that comparison with null and even its negation in most cases returns false. The exception is IS [NOT] NULL. In your case you may use either NVL function or OR WAREHOUSE IS NULL condition.

 

[Iby]

Sem, how is this NVL function works?

 

[sem]

NVL(parameter, value) returns value if parameter is null, otherwise it returns parameter.

WHERE nvl(WAREHOUSE,'aa') not in ('dd','di','dx') returns the result you need.