SELECT Ordprod.orderid, Ordsize.orderprodid,; Count(Ordsize.ordered) AS cntordered,; SUM(Ordsize.ordered) AS totordered,; SUM(Ordsize.allocated) AS totallocated,; SUM(Ordsize.shipped) AS totshipped, Ordhead.sbo AS specialord; FROM Ordsize ; INNER JOIN ordprod ON Ordprod.orderprodid = Ordsize.orderprodid ; INNER JOIN ordhead ON Ordprod.orderid = Ordhead.orderid; GROUP BY 2, 1, 7; ORDER BY Ordsize.orderprodidAs I read about the cartesian interpretation<g>.