Natural Inner Join Tab
You can use the Natural Inner Join tab to define a natural inner join. Natural inner joins return only the subset of rows from the left-hand table that matches rows from the right-hand table. Matches are done on all fields that have matching names in both tables. The Natural Inner 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.