UPDATE product p LEFT JOIN ( SELECT product_name, COUNT(*) AS quantity FROM order_detail GROUP BY product_name ) AS d ON d.product_name = p.
確定! 回上一頁