Dear All,
I have written a small query but it is giving some problem. The query is as follows
select
(case
when A.debpayacct = '_SYS00000000043' and A.vatstatus = 'Y' then c.vatgroup = 'S1-LB'
when A.debpayacct = '_SYS00000000043' and A.vatstatus = 'N' then c.vatgroup='S2-LB'
when A.debpayacct = '_SYS00000000044' and A.vatstatus = 'Y' then c.vatgroup='S1-LD'
when A.debpayacct = '_SYS00000000044' and A.vatstatus = 'N' then c.vatgroup='S2-LD'
end)as
FROM OCRD A JOIN ORDR B ON A.CardCode = (select $[b.cardcode])
join rdr1 C on B.docentry = C.docentry
Thanks & regards
Tavargeri Ganesh