SELECTSUM(eggs) as sqTotalEggs, SUM(hi_eggprice * eggs) as sqTotalAmt ;
FROM ( ;
SELECT hi_chicks / hi_htchpct as eggs, ;
hi_eggprice ;
FROM it!hatcinfo ;
WHERE hi_invnum = 'A0017' ;
AND !DELETED() ;
) as A ;
intoCURSOR curs2
Not Tested
Roses are #FF0000 Violets are #0000FF all my base are belong to you