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