LISTING A: Query That Uses EXISTS Instead of DISTINCT

SELECT *
FROM Email E
WHERE EXISTS(SELECT *
             FROM FT_EmailSubject FT
             WHERE E.MessageID = FT.MessageID
               AND FT.Word = 'Rose')