Hi All,
On the query below i would like to display only one record per sales order and to have the total shipped weight.
I appreciate your help. Thanks.
SELECT T0.DocDueDate, T0.DocNum, T0.CardName, T1.whscode, T0.DocDate, T1.weight1
FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.DocDueDate>=[%0] and T0.DocDueDate<=[%1] and T1.whscode LIKE '%' + [%2] + '%' and T0.DocStatus = 'C' and
ORDER BY T0.DocDueDate, T0.DocNum