Self Joins

Definition: Self joins allow you to retrieve related records from the same table. The most common case where you'd use a self-join is when you have a table that references itself