Get All cenvat taxcode using sql query

[former_member275826]

Dear all,

I want to all cenvat taxcode.

I have used foll query. bt not giving proper result.

SELECT T0.CODE,NAME FROM OSTC T0

INNER JOIN OTFC T1 ON T0.TfcId=T1.AbsId

INNER JOIN TFC1 T2 ON T1.AbsId=T2.TfcId

WHERE T2.TYPEID IN (SELECT ABSID FROM OSTT  WHERE nftaxid=-50)

GROUP BY T0.CODE,NAME

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT T0.[Code], T0.[Name] FROM OSTC T0  left JOIN OTFC T1 ON T0.TfcId = T1.AbsId left JOIN TFC1 T2 ON T1.AbsId = T2.TfcId GROUP BY T0.[Code], T0.[Name]

Thanks & Regards,

Nagarajan