I think I've tried every SQL I've seen and every Has/Does Not Have combination to figure out which constituents do not have an email address. Primary No/Yes isn't working. I just want a list of people who have absolutely no address anywhere, including login. I also tried email address does not have or not like %@%. Does anyone have a clue how to figure this out?
Thanks in advance.
There's not really an out of the box way to do it. Primary Yes/No says who's in the email table and then primary yes/no. You can make a dynamic list of every one who has any email than then use that list as a does not have criteria. You can also write a manual subquery like this instead, but you'll have to add it every time you change other criteria in the graphic interface.
AND NOT EXISTS (select 1 from vs_eaddress (Nolock) where a.customer_no = vs_eaddress.customer_no)
Ann