How to: Add Derived Tables to Queries (Visual Database Tools)
New: 17 July 2006
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
Open an existing query or create a new query.
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
Tasks
How to: Create Queries (Visual Database Tools)
How to: Open Queries (Visual Database Tools)
Other Resources
Performing Basic Operations with Queries (Visual Database Tools)
SELECT (Transact-SQL)