Skip to Content
0
Former Member
May 09, 2010 at 03:53 PM

Query

13 Views

Hi

SELECT sum(T1.[TaxSum]) FROM OSTT T0 INNER JOIN RDR4 T1 ON T0.AbsId = T1.staType INNER JOIN ORDR T2 ON T1.DocEntry = T2.DocEntry WHERE (T0.[AbsId]=-90 or T0.[AbsId]=-60 or T0.[AbsId]=-55 or T0.[AbsId]=-10 or T0.[AbsId]=5 or T0.[AbsId]=6) AND (T2.[DocNum] =$[ORDR.docnum] AND T2.[DocDate] =$[ORDR.docdate])

This query is giving erro after i have written line T2.[DocDate] =$[ORDR.docdate]

Thanks