在某些Microsoft Access查询上,我收到以下消息:操作必须使用可更新的查询。(错误3073)。我通过使用临时表来解决它,但是我想知道是否有更好的方法。所有涉及的表都有一个主键。这是代码:
UPDATE CLOG SET CLOG.NEXTDUE = (
SELECT H1.paidthru
FROM CTRHIST as H1
WHERE H1.ACCT = clog.ACCT AND
H1.SEQNO = (
SELECT MAX(SEQNO)
FROM CTRHIST
WHERE CTRHIST.ACCT = Clog.ACCT AND
CTRHIST.AMTPAID > 0 AND
CTRHIST.DATEPAID < CLOG.UPDATED_ON
)
)
WHERE CLOG.NEXTDUE IS NULL;
凤凰求蛊