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 Writing SQL Code in PowerDesigner).
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

The following tabs are available:

SQL tab - displays the SQL code for the query. You can edit the query directly in this tab or in PowerDesigner's built-in SQL Editor (see Writing SQL Code in PowerDesigner) by clicking the Edit with SQL Editor tool or in an external editor by clicking the Edit with tool (CTRL+E). Any edits you make in this tab will propagate to the query's other tabs and the SQL Query tab of the parent view, as changes made in other tabs will propagate here and to the parent view.
Tables tab - lists the tables in the FROM clause.You can add or delete tables in the list, and reorder the list using the arrows at the bottom of the tab. For each line, select a table or click the elipsis button to enter a more complex expression in the SQL Editor and, optionally, enter an alias in the Alias column. For the second and subsequent lines in the list you can specify an appropriate join condition keyword, and then specify the join condition.
Columns tab - lists the columns in the SELECT clause. You can add or delete columns in the list, specify aliases for them, and reorder the list using the arrows at the bottom of the tab.
Where tab - lists the expressions in the WHERE clause.You can add or delete expressions in the list, and reorder the list using the arrows at the bottom of the tab. For each line, select a column in each of the two Expression columns (or click the ellipsis button to specify a more complex expression), and select the appropriate operator between them. You can optionally enter a prefix and suffix.
Group By tab - lists the columns in the GROUP BY clause. You can add or delete columns in the list, and reorder the list using the arrows at the bottom of the tab.
Having tab - lists the expressions in the HAVING clause. You can add or delete expressions in the list, and reorder the list using the arrows at the bottom of the tab. For each line, select a column in each of the two Expression columns (or click the ellipsis button to specify a more complex expression), and select the appropriate operator between them. You can optionally enter a prefix and suffix.
Order By tab - lists the columns in the ORDER BY clause. You can add or delete columns in the list, and reorder the list using the arrows at the bottom of the tab. For each line, select a column (or click the ellipsis button to specify a more complex expression), and select ASC or DESC for the sort direction.