1
Answer

T0.docentry is invalid because of Group By

Ramco Ramco

Ramco Ramco
Dec 21
234
1

Hi

 IN below code i am getting error T0.docentry is invalid because of Group By

SELECT Sum(T0."DpmAmnt")  - (Select Sum(A0."DrawnSum") from ACH9 A0 where A0."BaseDocNum" = T0."DocEntry") As "NetAmount"
FROM ODPR T0 WHERE T0."CardCode"  = 'S04563'

 

Answers (1)
Next Recommended Forum