can do inner join on yhe same table? code example Example: self join SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;