LEFT JOIN #Phones P ON P.Phone_SID in (F.MobilePhone_SID, F.HomePhone_SID, F.OfficePhone_SID, F.PrimaryPhone_SID, F.SecondaryPhone_SID)
cani write this into
Left jion #Phones P ON P.Phone_SID = F.MobilePhone_SID and P.Phone_SID =F.HomePhone_SID and P.Phone_SID =F.ScondaryPhone_SID
correct or wrong of my assumption
New contributor
Veera Brahmam Vunnam is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.