How to: Modify Join Operators
By default, the Query and View 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.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
To modify join operators
In the Diagram pane, right-click the join line you want to modify, and then choose Properties from the shortcut menu.
In the Property window, click Join Condition and Type and click the ellipses (…) to the right of the property.
In the Join dialog box select a new operator.
See Also
Tasks
Concepts
How to: Join Tables Automatically