CREATE CURSOR test (SB c(10), DET c(10), KOL int, SummKol int)

INSERT INTO test values('Вася', 'Рука', 1, 0)
INSERT INTO test values('Петя', 'Рука', 1, 0)
INSERT INTO test values('Катя', 'Нога', 1, 0)
INSERT INTO test values('Катя', 'Рука', 1, 0)
INSERT INTO test values('Катя', 'Рука', 1, 0)
INSERT INTO test values('Вася', 'Рука', 3, 0)

UPDATE test SET SummKol = sAA.SummKol ;
from ;
(SELECT SUM(CC.KOL) as SummKol, cc.SB, cc.DET FROM test CC GROUP BY cc.SB, cc.DET) as sAA;
where sAA.SB = test.SB AND sAA.DET = test.DET

UPDATE ТутИмяТаблицыВкоторойНадоИзменитьSummKol SET SummKol = sAA.SummKol ;
from ;
(SELECT SUM(CC.KOL) as SummKol, cc.SB, cc.DET FROM ТутИмяТаблицыВкоторойНадоИзменитьSummKol CC GROUP BY cc.SB, cc.DET) as sAA;
where sAA.SB = test.SB AND sAA.DET = test.DET

CREATE CURSOR test (SB c(10), DET c(10), KOL int)

INSERT INTO test values('Вася', 'Рука', 1)
INSERT INTO test values('Петя', 'Рука', 1)
INSERT INTO test values('Катя', 'Нога', 1)
INSERT INTO test values('Катя', 'Рука', 1)
INSERT INTO test values('Катя', 'Рука', 1)
INSERT INTO test values('Вася', 'Рука', 3)

SELECT BB.SB, BB.DET, BB.KOL, AA.SummKol ;
from test BB;
inner join ;
(SELECT SUM(KOL) as SummKol , SB, DET FROM test GROUP BY SB, DET) as AA ON aa.SB = BB.SB AND aa.DET = BB.DET;
into CURSOR TestPRN

SELECT TestPRN
BROWSE