Panels › (DQI50) Join Condition: Secondary Table

(DQI50) Join Condition: Secondary Table

 =>
 
 --------------------------------------------------------------------------DQI50
 DATAQUERY: JOIN CONDITION: SECONDARY TABLE        QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Select a column from your secondary table ________________________________
 that corresponds to ________________________________
 from your primary table ________________________________
 by placing any character next to the desired name.
 -------------------------------------------------------------------------------
 SELECT| COLUMN NAME                      |  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 column of the primary 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 column to be used for joining with the primary table column.

Display Fields

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

QUERY NAME:

Name you assigned this query.

secondary table ____

The table you selected as the second one to be read in joining tables.

corresponds to ____

Column you selected from the primary table whose value will match values in the key you will select from the secondary table names listed on this panel.

primary table__

The table you selected as the first one to be read in joining tables.

Columns

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

SELECT

Place a character next to the name of a key in the secondary table whose values will match values in the key or column selected for joining in the primary table.

COLUMN NAME

Lists all columns in the secondary table. Scroll forward to see any additional names.

DESCRIPTION

Description, if any, of 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 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.