I am attempting to sum up the number of parts on hand for given groups in the OrgTble column. The query below is working correctly, but it is not showing groups that have zero items in stock.
I would like for it to show something similar to the table below (It would not currently show the Shelf C 0).
Shelf A 5
Shelf B 10
Shelf C 0
How can I get the query below to show groups that do not currently have items in stock?
SELECT OrgTable, SUM(QtyOnHand) AS Quantity FROM All_Assets WHERE
(PartNumber = '015533913') GROUP BY OrgTable