[sql]select e.column_name1
from table_name e, table_name f
where e.column_name1 =f.column_name1 and e.column_name2=f.column_name2[/sql]