To Get Except

select * from V_EMailDefaults except
(select distinct V_EMailDefaults.* from V_EMailDefaults
inner join #tempEntities on V_EMailDefaults.EmailType collate SQL_Latin1_General_CP1_CI_AS = #tempEntities.EmailType collate SQL_Latin1_General_CP1_CI_AS
and V_EMailDefaults.Language collate SQL_Latin1_General_CP1_CI_AS= #tempEntities.Language collate SQL_Latin1_General_CP1_CI_AS)) a

WHERE (Entity = 'default')
and EntityType = #ENTITYTYPE#
^ and EmailType = #EMAILTYPE# ^