SQL Server is very particular about clauses order. The ORDER BY has to be after the GROUP BY.

>I'm getting "Incorrect syntax near the keyword 'GROUP'."
>
>

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

>
>This runs fine if I remove the GROUP BY clause