>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

SET DELETED ON

SELECT ;
   SUM(hi_chicks / hi_htchpct *hi_eggprice)/SUM(hi_chicks / hi_htchpct) AS lnAggregatePrice ;
,  SUM(hi_chicks / hi_htchpct) as sqTotalEggs ;
,  SUM(hi_chicks / hi_htchpct*hi_eggprice) as sqTotalAmt ;
FROM it!hatcinfo ;
WHERE hi_invnum = 'A0017' ;
into CURSOR RESULTS

? lnAggregatePrice