Hi All:

Is there any way to consolidate the following code in to one SQL statement?

* table HATCINFO

* hi_chicks	hi_htchpct	hi_eggprice
* 9101		.8618			2.30	    
* 42413		.8033			1.95


SELECT hi_chicks / hi_htchpct as eggs, ;
hi_eggprice ;
FROM it!hatcinfo ;
WHERE hi_invnum = 'A0017' ;
AND !DELETED() ;
INTO CURSOR curs1

SELECT SUM(eggs) as sqTotalEggs, SUM(hi_eggprice * eggs) as sqTotalAmt ;
FROM curs1 ;
into CURSOR curs2

lnAggregatePrice = sqTotalAmt / sqTotalEggs

? lnAggregatePrice 

The lnAggregatePrice should equal 2.01.

Thanks!

Yossi