Fixed assets join logical

I am trying to get a join logical created over the three main Fixed Asset
files - QAT (Main Asset File), QDB(Depreciation Book), & QRM(Retirement).  I
have never done a join with three files with such a difference of "keys" and
I am having trouble trying to figure out how to code the join logical.  

The three logicals to be used are QATL10, QDBL04, & QRML07.

                Display Access Paths         
                                      
 Library   File            Format        Key Field  Seq   Select/Omit Values

 BPCSF   QATL10     IPQ100AT   ATOGST     A

                                                      ATPRIM      A

                                                      ATSECN     A

                                                      ATRCID
S EQ 'AT'                        
                                                      ATSTAT
A EQ '01'
BPCSF    QDBL04    IPQ100DB   DBASSN    A                                 
                                                      DBBKN      A

                                                      DBSTAT    A

                                                      DBSTAT               S
EQ '01'                       
                                                      DBSTAT               S
EQ '02'                       
                                                      DBSTAT               S
EQ '08'                       
                                                      DBSTAT               S
EQ '12'
BPCSF    QRML07   IPQ100RM   RMASSN    A                           
                                                      RMBKN      A

                                                      RMSEQN    A

                                                      RMSTAT              S
EQ '01'                 
                                                      RMSTAT              S
EQ '02'                 
                                                      RMSTAT              S
EQ '11'

TIA.  Any help would be appreciated.

Dilbert's Words Of Wisdom:
"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."

Dennis Munro    
Badger Mining Corporation
dmunro@badgerminingcorp.com <mailto:dmunro@badgerminingcorp.com> 

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---