I'm following this recipe:https://www.tessituranetwork.com/Help_System_v151h/Tessitura.htm#Recipe%20Books/Output%20Sets/Household%20Group%20Name.htm
which uses this statement:
(select a.individual_customer_no as 'customer_no', cast(a.group_customer_no as varchar) + ' : ' + b.lname as 'group_name' from T_AFFILIATION a join VS_CONSTITUENT b on a.group_customer_no = b.customer_no)
I set it up exactly ah sownin the doumentation. It works great but outputs all of the affiliations on an individual record. Can it be modified to only output household relationships?
Any assistance will be greatly appreciated.
Between the '= b.customer_no" and the final ")" you could add "and b.cust_type = 10".
(You can review customer types in TR_CUST_TYPE.)
Oh Thank you so much!