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

Select empnam , empno, typ1, Sum(total_cfil), Count(*) from mucurtw group by empnam , empno, typ1