1) the comparison of birthdate to min/max age determines what program the player is eligible for.

2)PlayerPrograms is the data table for players that have registered for a particular program.

2a)MemberPrograms is the data table for members that have registered for a particular program.

These are the two tables that I am having difficulty with in creating a filter to exclude them from the results.

3) I have attached a zip file to create the table structure and populate each table with some data.

Again, the original query produces a list of "programs" that a "player" and or "member" from a particular family are eligible to register for. The result set needs to exclude players or members that have already signed up for a given program ("playerprograms" and "memberprograms")