Panels › (DQIW0) Join Conditions: Multiple Conditions

(DQIW0) Join Conditions: Multiple Conditions

 =>
 
 --------------------------------------------------------------------------DQIW0
 DATAQUERY: JOIN CONDITIONS: MULTIPLE CONDITIONS    QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Below are the conditions you defined to join the two tables selected from the
 database.   Use the logical operators "AND", "OR", "(", and ")" to logically
 group your conditions.
 The default statement appears below.  You can type over it to change it.
 => ___________________________________________________________________________
 -------------------------------------------------------------------------------
       |COLUMNS FROM TABLE:            |RELATION|COLUMNS FROM TABLE:
 NUMBER| _____________________________ |OPERATOR| _____________________________
 -------------------------------------------------------------------------------
       |                               |        |
       |                               |        |
       |                               |        |
       |                               |        |
       |                               |        |
       |                               |        |
       |                               |        |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> NOT USED       <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

This SQL Mode Guided Query panel displays the join conditions you defined to describe the relationship between the two tables selected for this query. The default statement uses numeric identifiers CA Dataquery has assigned to each condition.

Action

Write over the default condition statement using and, or, or parentheses to arrange the conditions as needed. Name at least one join condition as a logical expression. Press <PF4> CONTINUE or Enter when finished.

Display Fields

Refer to the following chart for explanations of the display fields intended to contain variable data.

QUERY NAME:

Name of the query you are creating.

default statement

Default logical expression created by CA Dataquery to group condition statements.

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

Columns

Refer to the following for a discussion of each column on this panel.

NUMBER

Number assigned a condition.

COLUMNS FROM TABLE (1)

Column selected from first table for this condition.

RELATION OPERATOR

Operator used to compare column from first table to column from second table.

COLUMNS FROM TABLE (2)

Column selected from second table for this condition.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Exits the current panel.

<PF4> CONTINUE

Displays next Guided Query panel.

<PF6> DISPLAY QUERY

Displays query created so far.

<PF7> BACKWARD

Scrolls list backward one page.

<PF8> FORWARD

Scrolls list forward one page.