>SELECT Ordsize.orderprodid,; > SUM(Ordsize.ordered) AS totordered,; > SUM(Ordsize.allocated) AS totallocated,; > SUM(Ordsize.shipped) AS totshipped; > FROM ordsize ; > GROUP BY ordsize.orderprodid > >>
>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.orderid >>