SELF JOIN

A SELF JOIN is when a table is joined with itself.

It’s useful for comparing rows within the same table.

Syntax

SELECT a.column1, b.column2
FROM table_name a
JOIN table_name b ON a.common_column = b.common_column
WHERE condition;