Query design in Access

Question

I have created three queries and I need to consolidate them into a single query. They all have same foreign keys from another table. My objective is to have all the fields (primary key) from the main table displayed in the consolitated query regardless of whether there is record.

Please advise

Answer 1

Here is the outline using (left) outer joins

select ...
from mainTable M
left join Table2 T2
on M.key=T2.key
left join Table3 T3
on M.key=T3.key