Is there a way to select records in a table that are not linked to any other table
I have a table of people who completed volunteer applications and a table of various volunteer jobs and a many to many link to link the volunteers to the activities they actually performed. That is working fine. I want to find all the people on the table of people who completed a volunteer application who have never volunteered at all. Is there a way to do that?
Derrick Kotlus commented
Unless there is a field in the table that identifies whether or not the volunteer has completed an activity, you will need to use table relationships to get this figure. You can use the count() function to see how many child records (activities) that a volunteer has completed. Below is a great article on child functions for you to take a look at. Hope this helps!