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.

  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.

Community Additions