Hey friends,
I've tried using graphical edit in list builder to find accounts that have and do not have email addresses but no matter how I set the operators, I find accounts with email addresses coming in when I am saying "not in" or "does not have". We want to make sure we can call guests who do not have an email address to advise about show postponements or cancellations.
- Chris
Chris,
Have not tried List Manager elements, but if you want SQL for it, this should do the trick:
SELECT *FROM T_CUSTOMER c WITH (NOLOCK) LEFT JOIN T_EADDRESS e WITH (NOLOCK) ON c.customer_no = e.customer_noWHERE e.customer_no IS NULL
John
I've tried to get that to work in list manager and I get this error: Syntax Error in Query: Column names in each view or function must be unique. Column name 'customer_no' in view or function 'list_temp' is specified more than once. (List Sql)
It's times like this I wish I knew SQL better.
My bad. Replace the * with c.customer_no.
I was just pulling all the details, list manager always just wants the customer_no.
Thank you John. It's getting there. I need to figure out a few things like removing inactive accounts and such. It's just so not easy to get this data if you aren't a SQL genius.
Sorry, I have been in the back end and out of list manager often enough that I forget about things like inactive accounts. Also, I am often asked to include those numbers in the data I pull.
Add in this to the end to clear out inactive accounts:
AND c.inactive = 1