UPDATE语句中使用JOIN

举个例子~

UPDATE e SET e.money = e.money + d.amount
FROM employee e INNER JOIN 
(SELECT empid,amount=sum(amount) FROM deleted  WHERE rechargeable=1  GROUP BY empid) d  ON d.empid=e.id