grouping results in stock transfer query

[formerlyknownas]

I've made a query to display all items transferred according to some document numbers we're interested in investigating. How can we modify the query to group the items by name with a total count?

This is what I have so far:

SELECT T1.[Quantity], T1.[ItemCode], T2.[ItemName], T1.[WhsCode] FROM OWTR T0 INNER JOIN WTR1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode] WHERE T0.[DocNum] IN (13,23,29,49,55)

Any help is appreciated!

[hdolenec · Accepted solution]

SELECT SUM(T1.[Quantity]), T1.[ItemCode], T2.[ItemName], T1.[WhsCode] FROM OWTR T0 INNER JOIN WTR1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode] WHERE T0.[DocNum] IN (13,23,29,49,55) GROUP BY

T1.[ItemCode], T2.[ItemName], T1.[WhsCode]

[formerlyknownas]

Thanks Hrvoje. That worked.