Working with View Queries

You can edit queries associated with a view from the SQL Query tab of the view property sheet.

Any number of queries may be associated with a view, and the totality of their SQL statements is shown in this tab, linked by any of the standard SQL constructs, such as Union, etc.

You can edit the code shown in the SQL Query tab:

Directly in the tab
Click the Edit with SQL Editor tool to edit the code in the PowerDesigner SQL Editor (see Defining Queries with the SQL Editor).
Click the Edit with tool (CTRL+E) to open the code in your favorite editor

Any edits you make in this tab will propagate to the property sheets of the associated individual queries, which are available from the Query list at the bottom of the tab. Use the tools to the right of this list to create a new query (with the appropriate linking construct), delete the selected query, or open the property sheet of the selected query.

The following SQL constructs are available (if supported by your DBMS) for linking queries:

Construct	Result	Example
Union [default]	Displays all the data retrieved by both the queries, except where results are repeated.	SELECT 1: ABC SELECT 2: BCD Result: ABCD
Union All	Displays all the data retrieved by both the queries, including repeated results.	SELECT 1: ABC SELECT 2: BCD Result: ABCBCD
Intersect	Displays only the data retrieved by both the queries.	SELECT 1: ABC SELECT 2: BCD Result: BC
Minus	Displays only the data retrieved by one or other of the queries, but not by both.	SELECT 1: ABC SELECT 2: BCD Result: AD

Query Property Sheet SQL Tab
This tab displays the SQL code for the query.
Query Property Sheet Tables Tab
This tab lists the tables in the FROM clause, which specify where the query data will be drawn from.
Query Property Sheet Columns Tab
This tab lists the columns in the SELECT clause, which specify what data will be displayed in the query.
Query Property Sheet Where Tab
This tab lists the expressions in the WHERE clause, which restrict the data retrieved by the query.
Query Property Sheet Group By Tab
This tab lists the columns in the GROUP BY clause, which control how the data retrieved by the query will be grouped.
Query Property Sheet Having Tab
This tab lists the expressions in the HAVING clause, which restrict the data returned by a query with a GROUP BY clause.
Query Property Sheet Order By Tab
This tab lists the columns in the ORDER BY clause, which control the way in which the data retrieved by the query will be sorted.

Parent topic: Views (PDM)