An outer join allows you to display ALL records from one table, but only records in the other table that match the related fields.
[the_ad id=”12355″]
[the_ad id=”12356″]
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.