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.