add-derived-tables-to-queries-visual-database-tools.md

title	Add Derived Tables to Queries (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] joins [SQL Server], derived tables table joins [SQL Server] derived tables
ms.assetid	05f1ba1d-465f-4e36-84bb-21b963c9b8f9
author	stevestein
ms.author	sstein
manager	craigg

Add Derived Tables to Queries (Visual Database Tools)

Derived tables are result sets used as table sources in a query. You can add a derived table to a query in the Diagram Pane.

To add a derived table to a query

1. Open an existing query or create a new query.

2. Right-click the Diagram Pane and choose Add New Derived Table.

   A new table with the name derivedtbl_N is added, and the derived table's SELECT statement is added to the query's FROM clause.

See Also

Perform Basic Operations with Queries (Visual Database Tools)
Create Queries (Visual Database Tools)
Open Queries (Visual Database Tools)
SELECT (Transact-SQL)