SELF JOIN syntax

• To perform a SELF JOIN in SQL, the LEFT or INNER JOIN is usually used.
• SELECT column_names FROM Table1 t1 [INNER | LEFT] JOIN Table1 t2 ON join_predicate; Note: t1 and t2 are different table aliases for the same table.
• You can also create the SELF JOIN with the help of the WHERE clause.

The LEFT or INNER JOIN is typically used in SQL to execute a SELF JOIN. Table 1: t1: SELECT column_names [INNER | LEFT] JOIN Table1 to Table2 on the basis of the join_predicate; take note that t1 and t2 are different table aliases for the same table. The WHERE clause can also be used to establish the SELF JOIN.