I posted this on the RENXT FB page but I'm desperate for answers so I'm posting it here as well.
I need to pull a list of current and past parents who are alumni and also has or had a child attend the school.
I was instructed by someone to run the following queries then merge them using the AND operator. That seemed to have worked but now I’m noticing I’m missing the alumni who don’t have kids at our school who we also want to include in this list. Because their parents are listed but not them because they don’t have kids. Does that make sense? Based on my queries , shouldn’t they have been included? What am I missing?
Thank you in advance for your help!
