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 )