sql inner join same table code example Example: self join SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;