Hi everyone,
I'm new to SQL and I've got a question that's stumped me so if you have any ideas I would greatly appreciate it!
My goal is to have email addresses that have a login show up in my Output set results. I can get individual constituent information successfully, but for households if the login information is on the A1 or A2 profile and not on the household account, it is not showing up in my results. I tried checking the "primary group default" box TR_QUERY_ELEMENT and I get the same results as when the box is not checked. My entry in TR_QUERY_ELEMENT is:
Description: Customer login
Category: Eaddress
Data Select: !.login
Data from: (select * from T_CUST_LOGIN)
Data Where: blank
Does anyone have any ideas? Thanks for your help!
Joanne
Hi Joanne,
You could try changing the Data From statement to:
(select c.customer_no, l.login from V_CUSTOMER_WITH_HOUSEHOLD c join T_CUST_LOGIN l on l.customer_no=c.expanded_customer_no)
This will return the login details for any member of the household - but bear in mind it may return multiple rows, so make sure "Single Row" is not checked.
Hope this helps!
Martin
Thanks Martin! It does indeed return multiple rows and is what i was looking for.
Thanks for your help!