Modifying Join Operators

Modifying Join Operators

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

1. In the Diagram pane, right-click the join line you want to modify, and then choose Properties from the shortcut menu.
   
   
2. In the Join Line tab of the Properties dialog box, select a new operator from the list.
   –or–
   Change the operator in the SQL statement in the SQL pane.

See Also

Joining Tables Automatically | Joining Tables Manually | Querying Using Multiple Tables