Skip to Content
0
Former Member
Jun 30, 2009 at 10:05 AM

how to use group by in query

15 Views

In this query i want group by item description and quatity sum

SELECT T0.[Dscription], T0.[Quantity], T0.[OpenSum], T1.[DocNum], T2.[State] FROM DLN1 T0 INNER JOIN ODLN T1 ON T0.DocEntry = T1.DocEntry, CRD1 T2 WHERE T1.[CardCode] = T2.[CardCode] AND T1.[DocNum] Like '1_%%'