Hot answers tagged


Even though the count(c.EventDate)<1 part looks indeed suspicious, in reality, it is a valid condition, yet really unnecessary here, since you already have c.SubscriberID is NULL for the Left Exclusion Join. The problem is within your second LEFT JOIN which should be between _Job and _Sent because you want to find records that are not in the _Click Data ...

Only top voted, non community-wiki answers of a minimum length are eligible