I have two tables one with camper names and one with the camps they attend. There is a one to many relationship between the two.
I want a basic query that selects all campers registered in either "DC101" or "DC201" but who are not already registered in "DC102" or "DC202".
It should be quite straight forward but I am not finding myself able to make it work.
Any help would be appreciated.
Thanks in advance.
I want a basic query that selects all campers registered in either "DC101" or "DC201" but who are not already registered in "DC102" or "DC202".
It should be quite straight forward but I am not finding myself able to make it work.
Any help would be appreciated.
Thanks in advance.