SELF JOIN
Learn SELF JOIN (Joins, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A SELF JOIN joins a table to itself using two different aliases, so one row can be compared with or linked to another row of the same table. It is not a special keyword, just a normal join with the same table twice.