---
title: Query with Joins
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: 
  - "queries [Visual Database Tools]"
  - "View Designer, joins"
  - "table joins [SQL Server]"
  - "multiple table joins"
  - "Visual Database Tools [SQL Server], queries"
  - "Query Designer [SQL Server], joins"
  - "joins [SQL Server], queries"
ms.assetid: 8f068207-d777-4e64-8c4c-d821f0ddb450
author: markingmyname
ms.author: maghan
ms.manager: jroth
ms.reviewer: 

---
# Query with Joins (Visual Database Tools)
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
A query result can include data from multiple tables or table-valued objects. To combine data from multiple table-valued objects, you use the JOIN operation from SQL.  
  
For information about creating queries using multiple tables, see the following topics.  
  
## In This Section  
[Modify Join Operators (Visual Database Tools)](../../ssms/visual-db-tools/modify-join-operators-visual-database-tools.md)  
Specify that tables should be joined using an operator other than equal (=).  
  
[How the Query and View Designer Represents Joins (Visual Database Tools)](../../ssms/visual-db-tools/how-the-query-and-view-designer-represents-joins-visual-database-tools.md)  
Explains the graphic representation of the join as you see it in the Diagram pane.  
  
[Join Tables Automatically (Visual Database Tools)](../../ssms/visual-db-tools/join-tables-automatically-visual-database-tools.md)  
Steps for allowing the Query and View Designer determine if tables should be joined.  
  
[Join Tables Manually (Visual Database Tools)](../../ssms/visual-db-tools/join-tables-manually-visual-database-tools.md)  
Steps for creating a join manually in the Diagram pane.  
  
[Join Tables on Multiple Columns (Visual Database Tools)](../../ssms/visual-db-tools/join-tables-on-multiple-columns-visual-database-tools.md)  
Steps for joining tables with multiple criteria for each table.  
  
[Create Outer Joins (Visual Database Tools)](../../ssms/visual-db-tools/create-outer-joins-visual-database-tools.md)  
Specify that joined tables should include rows even when they do not match rows in the corresponding table.  
  
[Remove Joins (Visual Database Tools)](../../ssms/visual-db-tools/remove-joins-visual-database-tools.md)  
Steps for removing a join between tables.  
  
[Create Self-Joins Automatically (Visual Database Tools)](../../ssms/visual-db-tools/create-self-joins-automatically-visual-database-tools.md)  
Steps for allowing the Query and View Designer to create a self-join.  
  
[Create Self-Joins Manually (Visual Database Tools)](../../ssms/visual-db-tools/create-self-joins-manually-visual-database-tools.md)  
Steps for using a join to find subsets of data within a single table.  
  
[View Join Properties (Visual Database Tools)](../../ssms/visual-db-tools/view-join-properties-visual-database-tools.md)  
Steps for viewing the properties of a join.  
  
## Related Sections  
[Types of Queries (Visual Database Tools)](../../ssms/visual-db-tools/types-of-queries-visual-database-tools.md)  
Provides links to topics describing the supported query types.  
  
[Perform Basic Operations with Queries (Visual Database Tools)](../../ssms/visual-db-tools/perform-basic-operations-with-queries-visual-database-tools.md)  
Provides links to topics covering the most common query tasks.  
  
[Specify Search Criteria (Visual Database Tools)](../../ssms/visual-db-tools/specify-search-criteria-visual-database-tools.md)  
Provides links to topics covering the various kinds of search criteria and how to use them.