empnam,empno, typ1,total_cfil a 1 20 1 a 1 20 3 a 1 20 1 a 1 20 2 a 1 18 10 a 1 18 32 b b c c .. .. *********************** i need result from table mucurtw to new table or cursor sum typ1 and count typ1 it all fields is CHR type as.. empnam,empno, typ1,newtotal_cfil,count1 a 1 20 7 4 a 1 18 42 2 . .thanks