日期:2014-05-18  浏览次数:20458 次

多表查询后修改报错
SQL code
Update a
set a.FPlanTrategy='324'
from t_ICitem a , dbo.abc$ b

where   a.Fnumber=b.物料代码










消息 4422,级别 16,状态 1,第 1 行
View 't_ICitem' has an INSTEAD OF UPDATE trigger and cannot be a target of an UPDATE FROM statement.

------解决方案--------------------
根据视图找到相关字段 再做多表查询
SQL codeUpdate C
set c.FPlanTrategy='324'
from t_ICitem a , dbo.abc$ b table c

where a.Fnumber=b.物料代码 and c.Fnumber=b.物料代码