inserted and deleted tables can be quite useful, but they are definitely buyer beware because ...
- they don't always lend themselves to easy documentation
- they are invisible to client applications
- they may have performance, or scalability issues, due to expensive locks
That being said, I believe the below code should work for this case. One final caution/question may be around nullable columns in your two tables. If either email1 or email2 is nullable on any table, I would consider re-evaluating this code.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TRIGGER dbo.trig_i_tblNotInterested_MatchingEmail1AndEmail2
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
FROM dbo.tblListOf L
INNER JOIN inserted ins
ON L.email1 = ins.email1
AND L.email2 = ins.email2