Create Table #Temp1
(
Id Int,
nm varchar(40)
)
Create Table #Temp2
(
Id Int,
CallId Int
)
Insert into #Temp1
Values(1,'xx'),(2,'vv'),(3,'zz')
Insert into #Temp2
Values(1,09),(5,999)
Select t1.Id,t1.nm From #Temp1 t1
Left Outer Join #Temp2 t2 on t1.Id=t2.Id
Where t2.Id is null
Select t2.Id,t2.CallId From #Temp1 t1
Right Outer Join #Temp2 t2 on t1.Id=t2.Id
Where t1.Id is null
Select t1.Id,t1.nm,t2.CallId From #Temp1 t1
Inner Join #Temp2 t2 on t1.Id=t2.Id
Select COALESCE(t1.Id,t2.Id)[Id],t1.nm,t2.CallId From #Temp1 t1
Full Outer Join #Temp2 t2 on t1.Id=t2.Id
Drop Table #Temp1
Drop Table #Temp2