A self JOIN is a regular join, but the table is joined with itself. A self join simply specifies that each rows of a table is combined with itself and every other row of the table.
Syntax
SELECT a.column_name, b.column_name... FROM table1 a, table1 b WHERE a.common_filed = b.common_field;