---
title: "Query with Joins (Visual Database Tools) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
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: stevestein
ms.author: sstein
manager: craigg
---
# Query with Joins (Visual Database Tools)
  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)](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)](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)](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)](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)](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)](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)](remove-joins-visual-database-tools.md)  
 Steps for removing a join between tables.  
  
 [Create Self-Joins Automatically (Visual Database 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)](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)](view-join-properties-visual-database-tools.md)  
 Steps for viewing the properties of a join.  
  
## Related Sections  
 [Types of Queries (Visual Database 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)](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)](specify-search-criteria-visual-database-tools.md)  
 Provides links to topics covering the various kinds of search criteria and how to use them.