mtl_material_transactions ... SUM Produces Multiple Rows?
Can someone please explain to me why the query below is producing multiple rows for a single date?
I am baffled, I need to view the SUM(transaction_quantity) by date but the query produces multiple rows for the same date and I cant figure out why?
SELECT
transaction_date,
SUM(transaction_quantity)
FROM
mtl_material_transactions
GROUP BY
transaction_date
ORDER BY
transaction_date
;