Versuch es doch mal so...
SQL-Code:
SELECT DISTINCT a.emailadresse
FROM freischaltungen a
LEFT JOIN (SELECT DISTINCT emailadresse
FROM freischaltungen
WHERE produkt NOT IN ('P1', 'P2')) b
ON a.emailadresse = b.emailadresse
WHERE a.produkt IN ('P1', 'P2')
AND b.emailadresse IS NULL
Gruss
Thorsten