self join sql to check one column code example Example: self join SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition;