Master self joins - joining a table to itself

Use different aliases to distinguish same table

Model hierarchical relationships (employee-manager)

Find related records within same table

Compare rows within same table

Handle recursive relationships

Master self joins - joining a table to itself

Use different aliases to distinguish same table

Model hierarchical relationships (employee-manager)

Find related records within same table

Compare rows within same table

Handle recursive relationships