>hi all,
>
>i need help to create new table have records as..
>

>*mytable
>empno      file       no           val1        val2      
>1              2         6             500         80
>1              2        28            100         50
>1              3        10            200         70
>2              2          8            100        40
>2              4        18            150        60
>
>

>
>*result new cursor or table
>

>empno     count1   file          no       val1        val2      sum1(val1+val2)    
>1               3          7           44       800         200           1000                
>2               2          6           26       250        100            350
>

>
>thanks

Looks like what you want is:

SELECT empno, CNT(*), SUM(File), SUM(Val1), SUM(Val2), SUM(Val1 + Val2) ;
   FROM MyTable ;
   GROUP BY EmpNO ;
   INTO CURSOR MyResult

Tamar