Merge tables with different columns
I support an organization that has both members and volunteers. Member data includes start and end dates. Volunteer data includes interest areas. A query that draws data from both tables only gives me those people who are both members and volunteers. How can I create a query that produces all the people regardless of which category they are in and shows all the data appropriate to their category?