Creating An Outer Join Query In Access

In Access, there are two types of joins based on equality of matching fields (or columns) - inner joins and outer joins. An inner join, which is the default join type, combines rows from two tables or queries only if values in the joined fields match. The matching fields must have compatible data types or contain similar data. If one table or query doesn't have a matching field in the other table or query, neither row appears in the query's results. An outer join, on the other hand, includes rows even if they do not have matching fields in the joined table.