[sqr-users] Need Some help in a SQR Select

[Kaz.Narayanan@averydennison.com]

Hello All,

In my SQR, I am trying to select  a group of rows in PS  where the sum of
the amounts match some dolor amt.
Example.

In PS ITEM table we have following fields.
 ITEM
Balance amt
BUSINESS UNIT

let us say I have the following values in that table

      ITEM        Balance Amt       Business Unit
Row1  XYZ         100.00                  ABC
Row2     LMN            125.00                  KLM
Rwo2  KKK         40.00             PPP

in my SQR, I am trying to select row 1 and row 2 where the total of
Balance amt is 140.00 here is my procedure

Begin-Select
item

from ps_item HAVING sum(bal_amt) = 140
group by    ITEM

END-SELECT

I am not fetching any row, I am expecting the SQL to iterate with in all
rows where
it addes some rows to itself and sees where the total equals 140.00

any suggestions would be highly appreciated.

Thanks
Regards


Kaz.



-----------------------------------------
The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.


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