Self Joins Step by Step

A compact self-join book for readers who need exact finite alias behavior: one source table read through two aliases, candidate alias pairs, equality matches, explicit self-pair exclusion, manager/employee lookup, duplicate-role rows, NULL no-manager boundaries, qualified alias output columns, and guarded expected facts.