update...join

update...join

<!--sales插入数据时，根据vins更新inventory的number-->
<update id="update">
    UPDATE epc_inventory i JOIN
    (
      SELECT c.material_code,c.material_name,SUM(c.dh) number FROM epc_mes_components c
      JOIN  epc_mes_ovet v
      ON c.item_id = v.item_id
      WHERE v.vin IN (
        <foreach collection="vins" item="vin" index="index" separator=",">
            #{vin}
        </foreach>
      )
     GROUP BY c.material_code
    ) t
    ON t.material_code = i.material_code
    SET i.number = i.number + t.number
    WHERE i.country_area = #{countryArea}
</update>