你是什么数据库啊？
这是Mysql.。有问题，我再修改。
create trigger orderClose
after insert on receive
for each row
begin
set @sum=(select sum(qty) from receive where number=new.number group by number);
set @sumOrder=(select qty from order_info where num=new.number group by num);
if @sum=@sumOrder then
update order_info set valid="1" where num=new.number;
end if;
end//
drop trigger orderClose//
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024