Hi Folks:
I need to add the sum of quantity column.
Table SQL:
SELECT QUANTITY
FROM RECEIPTS_TABLE
WHERE REQUISTION := REQUISITION
AND FISCAL_YEAR := FISCAL_YEAR
AND LINE_NUMBER := LINE_NUMBER
I was thinking some kind of loop but couldn't figure it out. Any help would be appreciated.
Matthew