SELECT Ordsize.orderprodid,; SUM(Ordsize.ordered) AS totordered,; SUM(Ordsize.allocated) AS totallocated,; SUM(Ordsize.shipped) AS totshipped; FROM ordsize ; GROUP BY ordsize.orderprodidThe SYS(3054,11) Result is:
SELECT Ordprod.orderid, Ordsize.orderprodid,; SUM(Ordsize.ordered) AS totordered,; SUM(Ordsize.allocated) AS totallocated,; SUM(Ordsize.shipped) AS totshipped; FROM ; Ordsize ; INNER JOIN ordprod ; ON Ordprod.orderprodid = Ordsize.orderprodid ; GROUP BY Ordsize.orderprodid, Ordprod.orderidAgain the SYS(3054,11) Result is: