Thanks, Sergey. I guaess that means that I need to execute a subquery for each field I want.

Thanks,

Yossi

>A subqueryn in a field list can return only 1 value
>

...
>	(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 ;
>...

>>
>>What's wrong with this:
>>
>>

>>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
>>

>>
>>I am getting an invalid subquery message.