• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 90 views
  • Users 0 members are here
Related

Some SQL help needed

Tiffany Elliott
$organization

Hi folks,

We are doing a bit of data clean up and I'm stuck on a few queries I'm hoping someone can help with.

1.How many active Tessitura accounts have no email address? 

2. How many active Tessitura accounts have no mailing address?

3. How many active individual records are tied to household accounts that have giving history?

4. How many active individual records are tied to household accounts that have NO giving history?

I think this is because I can't seem to wrap my head around excluding a sub query.  

Any help on this would be greatly appreciated. 

Thanks,

Tiffany

Parents
  • $organization

    Regarding the household issue, I usually look at the V_CUSTOMER_WITH_PRIMARY_AFFILIATES view.

    SELECT * FROM V_CUSTOMER_WITH_PRIMARY_AFFILIATES WHERE cust_type = 7 and name_ind <> 0

    That should yield all A1 and A2 affiliates of any household. The customer_no would be the household # and the expanded_customer_no would be the individual affiliate #s. And you could use those to do a LEFT JOIN with T_CONTRIBUTION. If you want affiliates beyond the primary ones, I think you would have to dig into the relationship tables. I haven't worked much with those though.

Reply
  • $organization

    Regarding the household issue, I usually look at the V_CUSTOMER_WITH_PRIMARY_AFFILIATES view.

    SELECT * FROM V_CUSTOMER_WITH_PRIMARY_AFFILIATES WHERE cust_type = 7 and name_ind <> 0

    That should yield all A1 and A2 affiliates of any household. The customer_no would be the household # and the expanded_customer_no would be the individual affiliate #s. And you could use those to do a LEFT JOIN with T_CONTRIBUTION. If you want affiliates beyond the primary ones, I think you would have to dig into the relationship tables. I haven't worked much with those though.

Children
No Data