When joining tables, you can display a list of the table joins and modify the join type. Each table join has an associated join type.
To view or change the join type: From the Query Builder -Join Tables page:
Click Join to access the Joins dialog box, click the desired join under Current Joins, and select a join operator next to Join Type.
Double-click the arrow representing the join and select a join type in the Configure Join dialog box.