Dennis
2/25/2018 - 7:40 PM

WHERE NOT IN ()

Use the WHERE NOT IN () to exclude or Inlude people in your selecten.

SELECT * FROM [Table 1]
WHERE Email NOT in (
SELECT c.EmailAddress
FROM [DE - In Welkomsttraject] c
) AND
Email NOT in (
SELECT d.Email
FROM [DE - Overleden] d
)