mysql查询出数据更新到另一张表

update mall_products p
inner join(
    select
        product_id ,
        sum(inventory_count) stock
    from
        mall_styles
    GROUP BY
        product_id
) as sty on p.id = sty.product_id
set p.stock = sty.stock