Pro exercise

Exclude a suppression list safely

Build a mailing list that excludes everyone on the suppression list. The list contains blank rows, which silently empty a NOT IN query in SQL; exclude suppressed people without losing everyone else.

• anti-joins
• NULL semantics
• scope

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.