Specifying Query Joins

Use the Specify Query Joins page (PSCPQQRYJOINS) to define how selected queries (from the Select Base Query page) should be joined.

Navigation:

1. Select Reporting Tools, Composite Query, Composite Query Manager.

2. Select the Add a New Value tab.

3. Enter the basic information in the Specify Composite Properties page and click the Next button.

4. Select two base queries in the Select Base Query page and click the Next button.

This example illustrates the fields and controls on the Specify Query Joins page. Definitions for the fields and controls appear following the example.

Term	Definition
Joins	This section displays the query names and query alias of the selected queries. You can select a join type from the Join to Related Query drop-down list. The available values are Inner Join and Left Outer Join.
Query Join Details	Use this section to select the query fields and condition type used to join the selected queries. Query Field The first Query Field drop-down list includes the fields that you have selected as the output fields from the first base query. In the previous example, the first base query is QE_EMPLOYEE. Select a query field as a mapping field from the first Query Field drop-down list. Condition Type Select a value from the Condition Type drop-down list to define how the field values are compared. Only the subset of the condition types supported by PSQuery is supported by Composite Query. The available options are equal to, greater than, less than, not greater than, not less than, equal to, and not equal to. Query Field The second Query Field drop-down list includes the fields that you have selected as output fields from the second base query. In the previous example, the second base query is QE_JOBCODE. Select a query field as a mapping field from the second Query Field drop-down list.
Next	Click to advance to the Select Output Fields page.