Natural Full Join Tab
You can use the Natural Full Join tab to define a natural full join. Natural full joins return all matching rows and non-matching rows in the two tables included in the join. Matches are done on all fields that have matching names in both tables. The Natural Full Join tab contains the following elements:
Left side - Specifies the table used for the left side of the join.
Join type - Enables you to select a different join type.
Right side - Specifies the table used for the right side of the join.
Switch sides - Enables you to switch the tables from one side of the join to the other. The table on the left side moves to the right side, and the table on right side moves to the left side.
Add parenthesis - Adds a parenthesis around the join in the SQL code.