Hot answers tagged


In your 1st query there's a NULL returned by the subquery and you're a victim of Three-valued-logic. See also: A simple workaround is to add WHERE propid IS NOT NULL. But better switch to NOT EXISTS instead, which treats UNKNOWN as FALSE (i.e. Two-valued-logic): ...

Only top voted, non community-wiki answers of a minimum length are eligible