Community Contributions > SQL Workbench
report to show all clubbers missing Red 1:1?
(1/1)
kriswilkinson:
In our club, Red 1:1 is the only section we allow clubbers to skip and come back to at some point within the club year. Red 1:1 is Bring a Visitor to Club. Is there a way to run a report to find all clubbers who have not completed Red 1:1?
Thanks,
Kris
Rick Leffler:
I'll see if I can come up with an SQL statement for you and post it here.
kriswilkinson:
--- Quote from: Rick Leffler on April 12, 2012, 02:27:55 PM ---I'll see if I can come up with an SQL statement for you and post it here.
--- End quote ---
Any updates on the SQL statement?
Many thanks,
Kris
Bernard:
Try this:
select Filing_Name from section S join person P on S.Person_ID=P.Person_ID where
S.section_name = 'Red Jewel 1:1' and S.Completed = 'No' and P.Status = 'Active' order
by Filing_Name
Rick Leffler:
Thanks Bernard!
(This was originally posted in April. I clearly overlooked responding to this, sorry.)
Navigation
[0] Message Index
Go to full version