Hi All:

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.

Thanks,

Yossi