> That's the thing that's being treated as FALSE. That UNKNOWN. Not the value of...

		empthought 9 months ago \| parent \| context \| favorite \| on: SQL nulls are weird > That's the thing that's being treated as FALSE. That UNKNOWN. Not the value of NULL itself. No, it's being treated as UNKNOWN, and the semantics of SELECT...WHERE only returns rows where the value of the condition is TRUE. I think you need to look into https://en.wikipedia.org/wiki/Negation_as_failure