帮忙写一个触发器

[livi]

table1(id(主键）,ii(smallint) )
table2(id, id1,qty) ,
table3(id1,total)

table1通过id与table2相关联，table2通过id1与table3相关联,当ii被update 为1 时 ，用table2里每一个与id相同的记录更新table3中的total(total=total+qty)

不知说清楚没有？
谢谢！

[zx_ali]

update table3
set total=total+(select sum(qty) from table2 b where a.id=b.id ) from table3 a,table2 b
where a.id in (select id from table1)

[Yang_]

create trigger tr_table1_update
on table1
for update
as
if update (ii)
update table3
set total=total+(select sum(qty) from table2 b where a.id1=b.id1 and b.id in (select id from inserted where ii=1)) from table3 a
where id1 in (select id1 from table2 where id in (select id from innserted where ii=1))

go

怎么这么拗口呢？


go

[ropriest]

Creat Trigger trg_update ON table1
FOR update AS
update table3
set total=total+(select sum(qty) from table2 b where a.id=b.id ) from table3 a,table2 b
where a.id in (select id from table1)

[ropriest]

TO Yang_(扬帆破浪)
怎么好象在CS一样，呵呵

go！

go！

[Varchar]

呵呵，楼上高明！！

[bomber2001]

Creat Trigger trg_update ON table1
FOR update AS
update table3
set total=total+(select sum(qty) from table2 b where a.id=b.id ) from table3 a,table2 b
where a.id in (select id from table1)

ropriest(馆主) 不错啊，你的分数涨的真快啊，快要红星飘飘了

[livi]

谢谢大家！