NOT IN and NULLs Step by Step

A compact NOT IN book for readers who need exact finite SQL NULL behavior: input rows, literal and subquery-result candidate lists, TRUE/FALSE/UNKNOWN membership, NULL candidates making non-matches UNKNOWN, WHERE keeping TRUE only, a scoped NOT EXISTS contrast, and guarded expected facts.

NOT IN and NULLs