update join 连接语句批量更新

UPDATE wsy_dh.orderingretail_proxy_account p
JOIN (
	SELECT
		SUM(b.price) AS sum_prices,
		a.current_proxy_id
	FROM
		wsy_shop.system_send_order a
	LEFT JOIN weixin_platform.weixin_commonshop_order_prices b ON a.order_id = b.batchcode
	WHERE
		a.send_type = 1
	AND a.is_accept = TRUE
	AND a.isvalid = TRUE
	AND a.or_shop_type != 2
	AND b. STATUS = 1
	AND b.is_sendorder = TRUE
	GROUP BY
		a.current_proxy_id
) AS q ON p.proxy_id = q.current_proxy_id
SET p.sum_send_order_price = q.sum_prices

备注：

【库名】wsy_shop
【表名】system_send_order 系统派单表

order_id
current_proxy_id
send_type (1 订货系统)
is_accept （1）
isvalid	（1）
or_shop_type （！=2）
---------------------------------------------------------
【库名】weixin_platform
【表名】weixin_commonshop_order_prices 供应商订单表

id/batchcode
status (1)
is_sendorder （1）
//or_shop_type （！=2）

price
-----------------------------
【库名】wsy_dh
【表名】orderingretail_proxy_account 订货系统-代理商账户表

sum_send_order_price