modify-join-operators-visual-database-tools.md

title	Modify Join Operators
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	joins [SQL Server], operators modifying join operators join operators
ms.assetid	d1dcdcfd-166c-4147-85ab-43cadc63819b
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Modify Join Operators (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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.

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 Property window, click Join Condition and Type and click the ellipses (...) to the right of the property.

3. In the Join dialog box, select a new operator.

See Also

Join Tables Automatically (Visual Database Tools)
Join Tables Manually (Visual Database Tools)
Query with Joins (Visual Database Tools)