Self Join Joining a table to itself, using two aliases so the two copies can be told apart. When to use Listed among the key concepts of PS 04 (nested queries on Sakila). Give each copy its own Alias and join on the relating columns. See PS 04.