Hi, I think it could be done by using SQLSELECT but it's better to use an alias like this :
>SQLSELECT A.ACCT.NO, SUM(A.CR.AMT) FROM ACCOUNTS A GROUP BY A.ACCT.NO HAVING SUM(A.CR.AMT) > 10000.00 ; On Sep 27, 9:04 pm, jlogdup <[email protected]> wrote: > Maybe is more clear what I want to do it is like the clause HAVING in > oracle or sql server > > SELECT ACCT.NO, SUM(CR.AMT) > FROM ACCOUNTS > GROUP BY ACCT.NO > HAVING SUM(CR.AMT) > 10000.00 ; > > i want to do the same with JQL. > > Thanks in advance for your help, > > On Sep 27, 9:23 am, jlogdup <[email protected]> wrote: > > > Good Morning , > > I have this JQL > > > SORT ACCOUNTS BY ACCT.NO BREAK-ON ACCT.NO TOTAL CR.AMT DET-SUPP > > > I want to print only those accounts whose TOTAL CR.AMT greater than > > 10000.00, how I can do that ? > > > Thanks, -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
