Is there a SQL to pull members with no projects assigned?
Select Distinct Youth2a.MemberID, Youth2a.LastName, Youth2a.FirstName, Youth2a.Category, Youth2a.Status From “Youth2a.db” Youth2a WHERE (Youth2a.MemberID NOT IN (Select Distinct Youth2d.MemberID From “Youth2d.db” Youth2d)) AND Youth2a.Category IN (‘M’, ‘C’) AND Youth2a.Status IN (‘N’, ‘R’) Order by Youth2a.MemberID Judy Martin form Martech created these two SQL’s. ****Other SQL formulas can be found in the documents file of the Blue Ribbon Youth Enrollment program. Go to your main program file, select Youth Enrollment, documentation, Youth Enrollment 2.4 Manual, open the file and scroll down to the Appendix H 12- 18.
