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