SELECT d.sDepository_Desc, c.sCommodity_Desc, p.sProduct_CD, p.sProduct_Desc1, i.decInv_Physical_Qty, p.decProduct_Ozconv, i.decInv_Physical_Qty * p.decProduct_Ozconv AS Ounces FROM Product p JOIN Inventory i on i.sProduct_CD = p.sProduct_CD JOIN Commodity c on c.sCommodity_CD = p.sCommodity_CD JOIN Depository d on d.sDepository_CD = i.sDepository_CD ORDER BY i.sProduct_Cd, c.sCommodity_CD, p.sProduct_CD GROUP BY d.sDepository_Desc, c.sCommodity_Desc, p.sProduct_CDThis runs fine if I remove the GROUP BY clause