Ok, I give up. I've been trying to write a report (ODBC interface using
Crystal Reports).  Can anyone tell me why my nodes are listed 2 and 3 times
with different retentions?

Here is my SQL code:

SELECT
    ASSOCIATIONS.SCHEDULE_NAME, ASSOCIATIONS.NODE_NAME,
    BU_COPYGROUPS.COPYGROUP_NAME, BU_COPYGROUPS.VEREXISTS,
BU_COPYGROUPS.VERDELETED, BU_COPYGROUPS.RETEXTRA, BU_COPYGROUPS.RETONLY,
BU_COPYGROUPS.MODE, BU_COPYGROUPS.SERIALIZATION
FROM
    ADSM.ASSOCIATIONS ASSOCIATIONS,
    ADSM.NODES NODES,
    ADSM.BU_COPYGROUPS BU_COPYGROUPS
WHERE
    ASSOCIATIONS.NODE_NAME = NODES.NODE_NAME AND
    ASSOCIATIONS.DOMAIN_NAME = NODES.DOMAIN_NAME AND
    NODES.DOMAIN_NAME = BU_COPYGROUPS.DOMAIN_NAME
ORDER BY
    ASSOCIATIONS.SCHEDULE_NAME ASC,
    BU_COPYGROUPS.COPYGROUP_NAME ASC,
    BU_COPYGROUPS.MODE ASC,
    BU_COPYGROUPS.SERIALIZATION ASC,
    ASSOCIATIONS.NODE_NAME ASC



HERE IS WHAT IS OUTPUT:


                                                               VEREXIST
VERDELET   RETEXTRA   RETONLY
                      SCHEDULE NAM   2AM-TELE
                      COPYGROUP NAM  STANDARD
                      MODE           MODIFIED
                      SERIALIZATIO   STATIC
                                            PERI1              90       90
90         90
                                            PERI1              30       30
60         60
                                            PERI1              90       90
90         90


                      SCHEDULE NAM   DAILY_STD_BKUP
                      COPYGROUP NAM  STANDARD
                      MODE           MODIFIED
                      SERIALIZATIO   STATIC
                                            ABTRPN55           90       90
90         90
                                            ABTRPN55           30       30
60         60
                                            ABTRPN55           90       90
90         90
                                            RPDDSTEST1         90       90
90         90
                                            RPDDSTEST1         30       30
60         60
                                            RPDDSTEST1         90       90
90         90


                      SCHEDULE NAM   MIDNIGHT_BKUP_
                      COPYGROUP NAM  STANDARD
                      MODE           MODIFIED
                      SERIALIZATIO   STATIC
                                            CPTST30            30       30
90         90
                                            CPTST30            30       30
90         90
                                            RPDORC02           30       30
90         90
                                            RPDORC02           30       30
90         90







_____________________________
Diana J. Cline
Ross Products Division
614 / 624-3788