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
