Panels › (DQIT0) Join Condition: Define Relation

(DQIT0) Join Condition: Define Relation

 =>
 
 --------------------------------------------------------------------------DQIT0
 DATAQUERY: JOIN CONDITION: DEFINE RELATION         QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Define the relation by selecting a comparison operator to compare
      ________________________________  in  ________________________________
 with
      ________________________________  in  ________________________________
 
 Select one comparison operator:
      _ Equal ( = )
      _ Not equal ( ,= )
      _ Greater than ( > )
      _ Greater than or equal ( >= )
      _ Less than ( < )
      _ Less than or equal ( <= )
 
 When you have completed this join condition you can press <PF3> to define
 another join condition.  Press <PF1> for more information.
 
 -------------------------------------------------------------------------------
 <PF1> HELP      <PF2> RETURN           <PF3> REPEAT        <PF4> CONTINUE
 <PF5> NOT USED  <PF6> DISPLAY QUERY    <PF7> NOT USED      <PF8> NOT USED

Description

This SQL Mode Guided Query panel is used to select a comparison operator that will be used to define the relationship between the two columns you selected to join the two tables you are using in your query. The conditions you specify will be used to determine which rows in the tables will be joined.

Action

Select the type of comparison to be performed by entering a character over the underscore beside the comparison operator. Press <PF4> CONTINUE or Enter to go to the next step.

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.

Select

Refer to the following for explanations of the selections on this panel.

Equal

Data in first column matches data in the second column.

Not Equal

Data in first column does not match data in second column.

Greater than

Data in first column is greater than data in second column.

Greater than or equal to

Data in first column is equal to or greater than data in second column.

Less than

Data in first column is less than data in second column.

Less than or equal to

Data in first column matches or is less than in second 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

Exits the current panel.

<PF3> REPEAT

Creates another comparison for selection.

<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.)

<PF6> DISPLAY QUERY

View the query created so far.