SET ENGINEBEHAVIOR 70 >* #1 >CREATE CURSOR bsyear03 ( ; > detail i, noun C(1), quantity i) >INSERT INTO bsyear03 VALUES( 1, "A", 10) >INSERT INTO bsyear03 VALUES( 1, "B", 20) >INSERT INTO bsyear03 VALUES( 1, "C", 15) >INSERT INTO bsyear03 VALUES( 2, "D", 30) >Select detail, noun, sum(quantity) ; > from bsyear03 group by detail > >* #2 >CREATE CURSOR bsyear03 ( ; > detail i, noun C(1), quantity i) >INSERT INTO bsyear03 VALUES( 1, "C", 15) >INSERT INTO bsyear03 VALUES( 1, "B", 20) >INSERT INTO bsyear03 VALUES( 1, "A", 10) >INSERT INTO bsyear03 VALUES( 2, "D", 30) >Select detail, noun, sum(quantity) ; > from bsyear03 group by detail > >*Result > DETAIL NOUN SUM_QUANTITY >#1 > 1 C 45 > 2 D 105 >#2 > 1 A 45 > 2 D 105 >>>Sergey, to make it more meaningful perhaps I would do this....