Missing Matches Step by Step

A compact missing-match book for readers who need exact finite LEFT JOIN anti-match behavior: left rows to check, right rows that may match, left-preserving join rows, NULL padding, right-side IS NULL filtering, missing versus present outputs, matched duplicate rows staying out, and guarded expected facts.