Conference ilbbak::ibi_focus

310.0. "Rdb/FOCUS question" by KIDDER::TRUDEAU () Tue Feb 06 1990 15:22

    I am having a problem describing an Rdb database to FOCUS and was
    wondering if what I was trying to do was feasible.  Basically I
    am trying to set up a BOM structure.  There are many tables in the
    database but I will only describe two.
    
    EMP_PERSON contains information about employees with BADGE being
    the primary index.  Employee name among other attributes make up
    this table.
    
    EMPDECAD is also indexed by BADGE.  Within this table is also
    SUPV_BADGE but no supervisor name.  We would like to reference the
    EMP_PERSON table to get at the supervisor's first and last names.
    
    Can this be done?  I'll be glad to provide additional information
    as required.  Thanks for any help.
    
    Steve

  Steve,

    
     I wasn't able to use the multi-relation structure (embedded join) for 
your situation.  However if I defined the 2 relations in separate master
files and then JOINED the 2 files together with 2 separate JOIN statements
I was able to get the name information from the EMP_PERSON file for both the
employee badge AND the supervisor badge.

What I had was:

JOIN SUPV_BADGE IN EMP_TWO TO EMP_BADGE IN EMP_ONE AS J1
JOIN EMP_BADGE IN EMP_TWO TO EMP_BADGE IN EMP_ONE AS J2


                            Hope this helps


                                 KC

    Thanks KC.  Your solution does work.  We are struggling to find
    the appropriate syntax for the embedded join as distributing this
    solution would be preferable to distributing a customized profile.fex.