Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
By default, the Query and View Designer Tools (Visual Database Tools) 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.
Modify join operators
In the Diagram pane (Visual Database Tools), right-click the join line you want to modify, and then choose Properties from the shortcut menu.
In the Property window, select Join Condition and Type and select the ellipses (...) to the right of the property.
In the Join dialog box, select a new operator.