Advanced Database – Apply, modify an outer join
An outer join allows you to display ALL records from one table, but only records in the other table that match the related fields.
You can choose between a Left outer join or Right outer join in the Type drop-down menu.
Choosing Left join will display all records from the left-hand table, Right will display all from the right-hand table.