>*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 > >>
>empno count1 file no val1 val2 sum1(val1+val2) >1 3 7 44 800 200 1000 >2 2 6 26 250 100 350 >>
SELECT EmpNo,; COUNT(*) AS Count1,; SUM(File) AS File1,; SUM(No) AS No,; SUM(val1) AS val1,; SUM(val2) AS val2,; SUM(val1+Val2) AS Sum1; FROM YourTable; GROUP BY EmpNo; INTO CURSOR crsTest BROW NORMAL