... (SELECT SUM(lm_wldelvf) FROM lotmast ; WHERE lm_flcode = hi_flcode ) AS sum1, ; (SELECT SUM(lm_hddelvf) FROM lotmast ; WHERE lm_flcode = hi_flcode ) AS Sum2 ; ...>
>SELECT hi_flcode, SUM(hi_amt), ; > (SELECT SUM(lm_wldelvf), SUM(lm_hddelvf) FROM lotmast ; > WHERE lm_flcode = hi_flcode ) ; > FROM hatcinfo ; > WHERE SUBSTR(hi_flcode,5,4) <= lcFlockNumberEnd ; > AND SUBSTR(hi_flcode,5,4) >= lcFlockNumberBegin ; > GROUP BY hi_flcode ; >into CURSOR results >>