Approved Workman Database

Community Contributions => Q&A => Topic started by: ckim551 on March 04, 2020, 03:03:13 PM

Title: How to find a clubber with non-Primay E-mail?
Post by: ckim551 on March 04, 2020, 03:03:13 PM
Note: This post is applicable in the Legacy database as well as in the Cloud database's Windows App.

I've sent out an email to parents and got some returned email due to wrong email address.
I've got the email list using Gather Email Addresses.

Apparently the wrong email address is not a Primary Email.
How do I find out which clubber that wrong email address belong to?

Thanks,
Charles
Title: Re: How to find a clubber with non-Primay E-mail?
Post by: Rick Leffler on March 04, 2020, 05:21:18 PM
You can use the SQL workbench under the Tools menu to find which household the email address in question belongs to.  Type (or copy/paste) the following statement into the SQL Workbench and replace "email@gmail.com" with the actual email address you're looking for:

select h.filing_name as Household, c.display_as, c.contact_person  from household h, communication c
where c.household_id = h.id and display_as = 'email@gmail.com'
Title: Re: How to find a clubber with non-Primay E-mail?
Post by: ckim551 on March 04, 2020, 06:05:45 PM
That worked perfectly. Thank you for quick reply.