Skip to Content
Former Member
Oct 29, 2007 at 11:37 AM



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 !