Query Problem- trying to group by Item Group
I am creating a report which details the Item code, Item Description, In stock amount, Commited amount and the Price one particular price list. I want this to be grouped by the Item Group. The query below is the one I have created. It works well until i add anything into the Group by section.
FROM ITM1 T0 INNER JOIN
OITM T1 ON T0.ItemCode = T1.ItemCode
INNER JOIN OITW T2 ON T1.ItemCode = T2.ItemCode
INNER JOIN OITB T3 ON T1.ItmsGrpCod = T3.ItmsGrpCod
INNER JOIN OPLN T4 ON T0.PriceList = T4.ListNum
WHERE T4.[ListName] = 'Selling Prices GBP'
GROUP BY T3.[ItmsGrpNam]
I receive the following error when exectued:
Column 'OITM.ItemCode' is invalid in the select list because it is not contained in either an aggregate function or the GOUP BY clause
Can anyone help?
Thanks in advance
Edited by: Gail Patterson on Apr 3, 2008 1:32 PM