[sqr-users] Distinct in SQR

["Hall, Tara" <hallt@talgov.com>]

Hi All,

I'm using the following code in an SQR but it is still not returning distinct 
rows.  If I used the same code in TOAD, it returns distinct rows of data:

BEGIN-SELECT DISTINCT
D.ROLEUSER                      (+1, 15)
F.OPRDEFNDESC   
D.ROLENAME                      (0, 60)
E.CLASSID                       (0, 100)
F.ACCTLOCK                      
 
       LET #MYOBJNAME = 1
       
    FROM PSROLEUSER D, PSROLECLASS E, PSOPRDEFN F
    WHERE D.ROLENAME = E.ROLENAME
       AND E.CLASSID = 'PSADMIN'
       AND D.ROLEUSER = F.OPRID
       AND F.ACCTLOCK = 0
  ORDER BY 1
end-select


Any suggestions?

Thanks,
Tara

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users