Outer Joins Step by Step

A compact outer-joins book for readers who need exact finite left-outer-join behavior: base left/right tables, inner match pairs, preserved unmatched left rows, NULL padding, duplicate matches, NULL-key nonmatches, ON versus post-join WHERE filtering, and guarded expected facts.