試試這個
update Acc
set sum =
(select Acc.sum + mem.sale <<<-------
from Mem <<<-------
where acc.numb=mem.numb);
update Acc
set sum =
(select Acc.sum + mem.sale <<<-------
from Mem <<<-------
where acc.numb=mem.numb);
UPDATE TABLE1
SET TABLE1.FIELD1=TABLE2.FIELD2
FROM TABLE2
WHERE TABLE1.FIELD2=TABLE2.FIELD3
所以你的语法应该这么写
update Acc
set sum=sum+mem.sale
from mem
where acc.numb=mem.numb
楼上句子的也可以