UPDATE (t_inventory_sku t1,t_inventory_shelf_sku s)
LEFT JOIN (
SELECT
INVENTORY_ID,
SHELF_ID,
SKU,
ACTUAL_NUM actualNum,
OPERATE_PEOPLE,
UPDATE_USERID
FROM
t_inventory_shelf_sku
WHERE SHELF_ID = "203"
) AS t2 ON t2.INVENTORY_ID = t1.INVENTORY_ID AND t2.SKU = t1.SKU
SET
t1.ACTUAL_NUM = t1.ACTUAL_NUM - actualNum,
t1.DIFFERENCE_NUM = t1.DIFFERENCE_NUM - actualNum,
t1.LAST_UPDATE_TIME = now( ),
t1.UPDATE_USERID = "刘能",
t1.UPDATE_TIME = now( ),
s.UPDATE_USERID = "刘能",
s.UPDATE_TIME = now( )
WHERE t2.SHELF_ID = "203"
AND t2.INVENTORY_ID = t1.INVENTORY_ID AND t2.SKU = t1.SKU
注释:update后面的两张表必须用括号括起来,不然会报错