Query design in Access
I have created three queries and I need to consolidate them into a s开发者_Go百科ingle 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.
How can I acheive this?
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
精彩评论