Natural Left Join Tab

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