Skip to Content
0
Former Member
Dec 19, 2011 at 01:06 PM

Query

24 Views

Hai

i want to add CRD 7 .[TaxId0] below this query how do i will add? below query some place PAN number not appearing ?

SELECT DISTINCT T0.[CardName], T2.[TaxId0] as "PAN No.",T1.[WTCode], T3.[WTName], T3.[OffclCode] as Section, T1.[TdsBAmt] as BASIC, T1.[Rate], T1.[TdsAmnt] as Tax , T0.[DocDate] as Date FROM OPCH T0 INNER JOIN PCH5 T1 ON T0.DocEntry = T1.AbsEntry INNER JOIN PCH12 T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OWHT T3 ON T1.WTCode = T3.WTCode INNER JOIN PCH1 T4 ON T0.DocEntry = T4.DocEntry WHERE T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1] AND T4.[TargetType] <>'19' order by T3.[OffclCode],T0.[CardName]