编写触发器如下：

create trigger jf
on ICMORpt
for insert,update
as
begin
update t1 set t1.fheadselfj1111=(select sum(fentryselfj1144) from t2)/(select sum(fentryselfj1146) from t2)
from ICMORpt t1,ICMORptEntry t2
where t1.FInterID=t2.FInterID
end


调试没问题，但在做任务单汇报，保存时，系统提示无法找到t2表。
请各位帮忙看看程序有什么问题。谢谢！

期待有位路人能帮忙分析下原因，谢谢！

感觉触发器的语法存在一些问题, 我们改造了一下,如下SQL供参考:

create trigger jf
on ICMORpt
for insert,update
as
begin
update t1 set t1.fheadselfj1111=t2.fentryselfj1144/t2.fentryselfj1146
from ICMORpt t1,(select FInterID, sum(fentryselfj1144) as fentryselfj1144,sum(fentryselfj1146) as fentryselfj1146 from ICMORptEntry group by FInterID) t2
where t1.FInterID=t2.FInterID and t2.fentryselfj1146<>0

end