How to fetch common records from two tables?

SELECT * FROM Table1
INTERSECT
SELECT * FROM Table2