declare @t  table ( id int )
declare @e  table ( id int )

insert @t 
select 1
union all select 2
union all select 3

insert @e
select null
union all select 3

select 
    *
from        @t  t
left join   @e  e   on t.id = e.id
where
    e.id is null

select 
    *
from        @t  t
where
    t.id not in ( select e.id from @e e )

select 
    *
from        @t  t
where
    t.id not in ( select e.id from @e e where e.id is not null )

select 
    *
from        @t  t
where
    not exists ( select e.id from @e e where e.id = t.id )