Guest User

Untitled

a guest
Dec 17th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. SELECT e.recipient, c.contactProperty_createdate
  2. FROM Event as e
  3. WHERE NOT EXISTS
  4. (SELECT c.emailAddress, c.contactProperty_createdate
  5. FROM Contact as c
  6. WHERE c.emailAddress = e.recipient);
Add Comment
Please, Sign In to add comment