I have three tables that all share 2 fields (Name, IDNumber). Each table stores different information about the same people. I'm trying to combine them into one table. I run into a problem with the people that aren't in all 3 tables. I created a join query, but it only returns the records that have the Name and ID Number in all 3 tables. Is there any way to write a query that will also return the people who are only in 1 or 2 of the tables?



Thank you in advance for any assistance,

Jacob Salomon