Self-joins

In a self-join, a table is joined to itself by referring to the same table using a different correlation name.

 Example 1
 Example 2