Subqueries Step by Step

A compact subqueries book for readers who need exact finite subquery behavior: base tables, IN as semijoin, NOT IN with an explicit NULL caveat, EXISTS, NOT EXISTS, scalar one-row checks, scalar zero/many-row rejection, correlated per-row evaluation, and guarded expected subquery facts.