Panels › (DQI40) Join Condition: Primary Table

(DQI40) Join Condition: Primary Table

 =>
 
 --------------------------------------------------------------------------DQI40
 DATAQUERY: JOIN CONDITION: PRIMARY TABLE          QUERY NAME: _______________
 -------------------------------------------------------------------------------
 The primary table _______________________________ can be joined with the
 secondary table ________________________________ by relating a column from
 the first table to a column in the second table. Select the column to be used
 in the join from the primary table by placing any character next to its name.
 -------------------------------------------------------------------------------
 SELECT| COLUMN NAMES                       |  DESCRIPTION
 -------------------------------------------------------------------------------
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
       |                                    |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

You must complete this SQL Mode Guided Query panel if you selected a primary table and a secondary table for your query. The panel displays a list of columns from which you can choose one that will contain a value that will match a value in a key or column of the secondary table. These matching values will join rows from each table for the query's search for data.

Action

Type a character in the Select column next to the name of the key or column to be used for joining with the secondary table, key or column.

Display Fields

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

QUERY NAME:

The name you assigned this query.

primary table_

The table you selected first.

secondary table_

The table you selected for CA Dataquery to read second.

Columns

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

SELECT

Place a character next to the name of a column in the primary table whose values will match values in a column you will choose for the secondary table.

COLUMN NAMES

Columns in the primary table.

DESCRIPTION

Description, if any, for each column.

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

Returns to the Primary Table Selection panel.

<PF4> CONTINUE

Displays the next Guided Query panel when this one is complete. (Returning to this panel from a later panel will require that you redisplay any entry to save it again.)

<PF5> EXTEND COLUMN

Displays the extended column definition for key/column selected by cursor position.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.