Now I'm getting:
"Column 'Product.sProduct_Desc1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
I don't understand why all the columns listed in the SELECT clause have to be in the GROUP BY clause.
Can you enlighten me?
>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
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people