#

# LogiView

## Predefined Join Conditions art_agg, art_ref, and art_typ

| ### art_agg In case of a combined Select instruction of two tables (join selection), keywords are used to link the master table to Entity 1 and the relationship table.
    Entity 1 ------+    +------- Entity 2
                   |    |
               relationship table
| Where clauses of this type can only be used in combined select instructions ('select', 'where', 'exec_select'). The first variable of the parameter list of the Select command must be linked to a table field of the master table of Entity 1.
    Syntax:
art_agg Example: Combined Select instructions in the action part of a decision table. A database access to the master table of Entity 1 is defined for the 'ENT1' variable. Likewise, a relationship table database access is defined for 'AGG'. "RC" is a variable of type integer.
    select(ENT1,AGG)
    where(art_agg)
    RC = exec_select(1)
| 'Select' command, 'exec_select' integer function.
| ### art_ref In case of a combined Select instruction of two tables (join selection), keywords are used to link the master table to Entity 2 and the linked table.
    Entity 1 ------+    +------- Entity 2
                   |    |
               relationship table
| This keyword must be used as the argument of a Where condition in combined Select instructions ('select', 'where', 'exec_select'). The first variable of the parameter list of the Select command must be equal to a table field of the master table of Entity 2.
| Syntax: art_ref Example: Combined Select instructions in the action part of a decision table. A database access to the master table of Entity 2 is defined for the 'ENT2' variable. Likewise, a relationship table database access is defined for 'REF'. "RC" is a variable of type integer.
    select(ENT2,REF)
    where(art_ref)
    RC = exec_select(1)
| 'Select' command, 'exec_select' integer function.
| ### art_typ In case of a combined Select instruction of two tables (Join selection), keywords are used to link the master table to Entity 1 and the type table.
    Entity -----------type table
| This keyword must be used as the argument of a Where condition in combined Select instructions ('select', 'where', 'exec_select'). The first variable of the parameter list of the Select command must be equal to a table field of the master table.
| #### Syntax: art_typ Example: Combined Select instructions in the action part of a decision table. A database access to the master table of the entity is defined for the 'ENT' variable. Likewise, a type table database access is defined for 'TYP'. "RC" is a variable of type integer.
    select(ENT,TYP)
    where(art_ref)
    RC = exec_select(1)
| 'Select' command, 'exec_select' integer function.