请问如何整合下列的SQL语句,并完成更新操作?

Question

 SELECT     tempvendorwhlot_1.QTYS, tempvendorwhplan.QtyRequired
FROM         (SELECT     SUM(Qty) AS QTYS, VendorWHPlanId
                       FROM          dbo.VendorWHLot
                       GROUP BY VendorWHPlanId) AS tempvendorwhlot_1 INNER JOIN
                      dbo.VendorWHPlan tempvendorwhplan ON tempvendorwhlot_1.VendorWHPlanId = tempvendorwhplan.VendorWHPlanIdisupdate 是放在VendorWHPlan 表中的.
把上面的语句看成临时表，那么怎样才能把update tempvendorwhplan set isupdate=1整合在上面,条件是qtys=qtyrequired呢?thanks

Answer 1

简单点就是把上面的结果集当子表和你的更新表关联