To change an inner join relationship between tables for one query only to an outer join, you double-click the join line in Relationship Design view.

Inner Join

In database management, a type of join that returns only the records that have matching values in both tables being joined.

Outer Join

A SQL operation that returns all rows from one table and only those rows from another table that match the join condition, including rows with no match.

Relationship Design View

A feature in database management systems that allows users to visually layout and define relationships between different tables.