Declare @Student table(StudentID int identity,Name varchar(20))
Declare @Poke table(Poke_Id int identity,Poke_Giver_Id int,Poke_Receiver_Id int)
insert into @Student values('Alex'),('Bob'),('Caveman')
insert into @Poke values(1,2),(1,2),(2,1)
Select x.Poke_Id,x.Poke_Giver_Name,Poke_Receiver_Name = s.Name
from(
Select p.Poke_Id,s.Name Poke_Giver_Name ,p.Poke_Receiver_Id
from @Poke p
join @Student s
on p.Poke_Giver_Id = s.StudentID
)x
join @Student s on s.StudentID =x.Poke_Receiver_Id
/*
Poke_Id Poke_Giver_Name Poke_Receiver_Name
1 Alex Bob
2 Alex Bob
3 Bob Alex
*/
Niladri Biswas