love02xp

UPDATE CmpMoney SET AdMoney = 1
WHERE CmpMoney.CardID =
(SELECT addCardId, sum(adMoney) AS [SumMoney]
FROM addmoney
GROUP BY addCardId
having CmpMoney.CardID = addCardId.addCardId
);

我在Access中打算用如上语句来将CmpMoney 表中的AdMoney 字段值更新成SumMoney的值，
应该怎么写呢？

谢谢了先。。。

love02xp

收到，谢谢了。。。