Re: Report Results Not As Expected

[PINNI, BALANAND (SBCSI)]

I understand that u are using 3 aliases for 3 tables with join statements
for SQL.
I do remember as when u make equi join statements we have to make proper
comparison
i,e after WHERE statement.
Else for each record to be displayed it matches with all the records from
source table
,here in ur case it seams to be 3.Hence 3 times it displays.
This has been defined as some term in Oracle or SQL .
U can go to oracle web site with url get info on that.
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a76939/adg01dev.htm
Balanand Pinni
-----Original Message-----
From: Diana J.Cline [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: Report Results Not As Expected


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