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