---
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)
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
By default, the [Query and View Designer](../../ssms/visual-db-tools/query-and-view-designer-tools-visual-database-tools.md) 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](../../ssms/visual-db-tools/diagram-pane-visual-database-tools.md), 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)](../../ssms/visual-db-tools/join-tables-automatically-visual-database-tools.md)  
[Join Tables Manually (Visual Database Tools)](../../ssms/visual-db-tools/join-tables-manually-visual-database-tools.md)  
[Query with Joins (Visual Database Tools)](../../ssms/visual-db-tools/query-with-joins-visual-database-tools.md)