触发器问题

[wwfxgm]

触发器代码如下：
这里插入数据没有。但是删除有问题。 不知道哪里出错了？

 UPDATE  c
        SET     c.qty = t.qty ,
                c.total = t.total,
								c.zsje = t.zsje
        FROM    dbo.OrderHeader c
                JOIN ( SELECT   a.orderid ,
																sum(a.qty) as qty,
                                SUM(a.qty*b.price) AS total ,
                                SUM(a.qty*b.price*b.zk) AS zsje
                       FROM    dbo.OrderDetail a
                                JOIN dbo.jcjbxxb b ON b.id = a.bookid
                       WHERE    a.orderid IN ( SELECT orderid
                                                 FROM   inserted
                                                 UNION
                                                 SELECT orderid
                                                 FROM   deleted )
                       GROUP BY a.orderid
                     ) t ON c.id = t.orderid