why we use self join in sql code example Example: self join SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;