By default, the Query Designer joins tables using an equal sign (an equijoin), which matches values in the two join columns. If you want, you can change the operator used to compare values in the join columns.
To modify join operators
–or–
Change the operator in the SQL statement in the SQL pane.