intersect to do this
col1,col2,col3 FROM table1
col1,col2,col3 FROM table2
is some time like the inner join but inner join can give the duplicate values
but intersect not give the duplicate values this is the main difference between
inner join and intersect. In this way, INNER JOIN can simulate with INTERSECT
when used with DISTINCT.