sql server – Joining 3 tables together and selecting the null elements


select Name from Passagerare 
left join EB
on Passagerare.Personnr = EB.Personnr
left join MM 
on Passagerare.Personnr = MM.Personnr

where  Passagerare.Personnr = EB.Personnr or Passagerare.Personnr = MM.Personnr

I am trying to reverse the effect this gives me all the Name where Passagerare.Personnr = EB.Personnr or Passagerare.Personnr = MM.Personnr I want to reverse the effect the other users have null in both Passagerare.Personnr and MM.Personnr and I know I can use != null but is there any other way I can do that ?