在ACCESS2000中运行下面的查询,出现错误提示“操作必须使用一个可更新的查询”,请问如何解决?
UPDATE GLVchMaxNum AS B, (
SELECT FPeriod,FGroup,MAX(FNum) AS Num
FROM GLVch
GROUP BY FPeriod,FGroup
) AS A
SET B.FNum=A.Num
WHERE A.FPeriod=B.FPeriod AND A.FGroup=B.FGroup
...全文
314打赏收藏
请教ACCESS SQL 的问题
在ACCESS2000中运行下面的查询,出现错误提示“操作必须使用一个可更新的查询”,请问如何解决? UPDATE GLVchMaxNum AS B, ( SELECT FPeriod,FGroup,MAX(FNum) AS Num FROM GLVch GROUP BY FPeriod,FGroup ) AS A SET B.FNum=A.Num WHERE A.FPeriod=B.FPeriod AND A.FGroup=B.FGroup