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....