Query issue when key does not have both types of information in the table
I am using Access and need to add budget information together from 2 different tables in a query. Problem is the budget types are different and the stores that have the budget types sometimes have one budget type and not the other. When I combine the 2, only the stores that have both budget types show up in the query. If one store has a SAU Budget, but not a RES Budget, that store does not appear in the query. How do I fix this?