DECLARE @temp table
(ID int identity(1,1),
Name varchar(20)
)
DECLARE @temp1 table
(ID int identity(1,1),
Name varchar(20)
)

INSERT INTO @temp (Name)
SELECT 'AAA'
UNION ALL
SELECT 'BBB'
UNION ALL
SELECT 'CCC'
UNION ALL
SELECT 'FFF'

INSERT INTO @temp1 (Name)
SELECT 'AAA'
UNION ALL
SELECT 'EEE'
UNION ALL
SELECT 'GGG'
UNION ALL
SELECT 'FFF'


SELECT * FROM @temp
SELECT * FROM @temp1

SELECT * FROM @temp
INTERSECT
SELECT * FROM @temp1

output
----------------------------------
ID          Name
----------- --------------------
1           AAA
2           BBB
3           CCC
4           FFF

ID          Name
----------- --------------------
1           AAA
2           EEE
3           GGG
4           FFF

ID          Name
----------- --------------------
1           AAA
4           FFF