You can user INTERSECT : You can use Intersect Key word, which gives you common records.
You can do by this query also :
select A.column1, A.column2
from table1 A, table2 B
where A.column1 = B.column1
You will get the complete result set in above query.
Intersect will not return duplicates.
Hope you understand.
DNS Gold Member
"Failure is the path of least persistence"