Sales/Transaction totals by part, grouped by month
SELECT det.partNum,
SUM(det.quantity) AS Demand1,
COUNT(det.partNum) AS Call1
FROM details det
JOIN invoice inv […]
Original post by GPB
SELECT det.partNum,
SUM(det.quantity) AS Demand1,
COUNT(det.partNum) AS Call1
FROM details det
JOIN invoice inv […]
Original post by GPB
Leave a Reply
You must be logged in to post a comment.