#Intersect CReate table tableC(
ID int identity(1,1),
Name nvarchar (100),
Gender nvarchar(100)
)

insert into tableC
values ('Mark','Male'),
('Mary','Female'),
('Steve','Male')

Create table tableD(
ID int,
name nvarchar(200),
Gender nvarchar(100)
)
insert into tableD
values(2,'Mary','Female'),(3,'Steve','Male')

select ID, Name, Gender from tableC
intersect
select ID, Name, Gender from tableD



select tableC.ID, tableC.Name, tableC.Gender from tableC
inner join tableD on tableC.ID = tableD.ID