Natural Right Join Tab

You can use the Natural Right Join tab to define a natural right join. Right joins return matching rows and rows from the right-hand table that do not match any row in the left-hand table. Matches are done on all fields that have matching names in both tables. The Natural Right 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.