Question

ACCESS2010 Update语句报错“操作必须使用一个可更新的查询”

但实在是找不出原因了，网上的方法都试了。语句如下，请高手指教。
UPDATE Detail_Report as a, View_Job_Master_Count as b set a.[销售类型] ='1' where a.BU=b.[工程项目号]

View_Job_Master_Count :
SELECT DISTINCT Trim([工程 项目号]) AS 工程项目号, View_Job_Master.[经营单位 类型], View_Job_Master.[类别码 15], View_Job_Master.[实际 开始], Count(*) AS AccountNum
FROM View_Job_Master
WHERE View_Job_Master.[工程 项目号])<>''
GROUP BY View_Job_Master.[经营单位 类型], View_Job_Master.[类别码 15], View_Job_Master.[实际 开始], View_Job_Master.[工程 项目号];

View_Job_Master:
SELECT *, 'BOEC' AS Entity FROM Job_Master_BOEC
UNION ALL
SELECT *, 'GOEC' AS Entity FROM Job_Master_GOEC
UNION ALL
SELECT *, 'SOEC' AS Entity FROM Job_Master_SOEC
UNION ALL
SELECT *, 'OECC' AS Entity FROM Job_Master_OECC
UNION ALL SELECT *, 'CTOEC' AS Entity FROM Job_Master_CTOEC;

Answer 1

试试
UPDATE Detail_Report set a.[销售类型] ='1'
from Detail_Report as a, View_Job_Master_Count as b
where a.BU=b.[工程项目号]

Answer 2

试试UPDATE Detail_Report set a.[销售类型] ='1' from Detail_Report as a, View_Job_Master_Count as bwhere a.BU=b