I hav a simple query,
SELECT Distinct T0.DocEntry, T0.[DocTotal] FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocDate] = [%0] and T1.[WhsCode] = 01
here i need to get sum of those document total.
but being linked with row table wen ever there exists more than 1 item the doctotal too is getting displayed tht much times. so i find it hard to get the Sum(docTotal).
i tried by giving the distinct option for DocEntry after 'Where' , but dint get any result.
Thks in advance !