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

title	Add Derived Tables to Queries
ms.prod	sql
ms.prod_service	sql-tools
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	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer
ms.custom	seo-lt-2019
ms.date	01/19/2017

Add Derived Tables to Queries (Visual Database Tools)

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