Self join

Also written: self-join

A table joined to itself using two aliases, as if it were two tables. In staff it shows each person next to their manager.