>> >>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_CD >> >>>>