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.