View Single Post
Old 08-23-2019, 11:22 AM   #1
Richard1941
Newly Registered User
 
Join Date: Oct 2012
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Richard1941 is on a distinguished road
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?

Richard1941 is offline   Reply With Quote