Pull multiple fields from table B where a specific value from Table A is not in Table B
Based on your comment


  The task is to find all contacts in the Contact table that are not in
  the Event table, and pull their email address AND their contact
  creation date.


Why doesn't this work?

SELECT c.emailAddress
    ,c.contactProperty_createdate
FROM Contact AS c
WHERE NOT EXISTS (
        SELECT *
        FROM Event AS e
        WHERE e.recipient = c.emailAddress
        );