The equivalent MySQL statement would be like this: UPDATE inventory JOIN (SELECT sum(quantity) AS amt, itemId FROM sales GROUP BY 2) AS daily ...
確定! 回上一頁