amt FROM (SELECT sum(quantity) AS amt, itemId FROM sales GROUP BY 2) AS daily WHERE inventory.itemId = daily.itemId;. The subquery in the FROM clause computes ...
確定! 回上一頁