UPDATE SKU SET STD_COST_PRICE = GOODS.STD_COST_PRICE, UPDATE_USER_NAME = 'MODIFY', USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM GOODS
LEFT JOIN (
SELECT GOODS_CODE, round(avg(STD_COST_PRICE)) AS m FROM SKU GROUP BY GOODS_CODE
) AS a
ON
GOODS.GOODS_CODE = a.GOODS_CODE
WHERE
SKU.GOODS_CODE = GOODS.GOODS_CODE and
SKU.STD_COST_PRICE < a.m