Self Joins Association, Self Join Syntax SELECT column_name (s) FROM table1 T1, table1 T2 WHERE condition; .