谢谢奇奇!
我按你的方法写:update B set B.stockQty=B.stockQty-deleted.Qty
显示107错误:列前缀“DELETED"与查询中所用的表名或别名不匹配。
谢谢邹建!
你的代码没有错误,我是这样写的:
create trigger inout_deleted
on A
for delete
as
update B set stockQty=B.stockQty-deleted.Qty
from B,(select invcode,Qty=sum(Qty) from deleted group by invcode)deleted
where B.invcode=deleted.invcode
但我不知这句from B,(select invcode,Qty=sum(Qty) from deleted group by invcode)deleted
中B后一个逗号,和括号后一个DELETED是什么意思???帮我解答一下吧!!!
create trigger tr_delete_A on A
for delete
as
update B set 库存=b.库存-d.库存
from B,(select 材料编号,库存=sum(数量) from deleted group by 材料编号)d
where b.材料编号=d.材料编号