Hi,
When iam executing this below query it's showing error :
1. [Microsoft SQL] [SQL Native client][SQL Server] Must specify table to select form
2.[Microsoft SQL] [SQL Native client][SQL Server] 'Statement Search funtion'(SEWS) (s) could not be prepared.
SELECT g.* FROM
(select T0.shortname,b.cardname,T1.number as BillNo,T1.refdate as BillDate,
[Serv Chrgs - CLRS]=case when (Select sum(c.debit)from jdt1 c where T1.transid=c.transid and c.account='4070101001')is not null then (Select sum(c.debit)from jdt1 c where T1.transid=c.transid and c.account='4070101001') else 0 end,
T0.profitcode as [Customer/Vendor Code],oprc.prcname as [Customer/Vendor Name], '0' as U_Servicecharges, T1.ref2
from OJDT T1
inner join jdt1 T0 on T0.transid=T1.transid
left join ocrd b on b.cardcode=T0.shortname
inner join oprc on oprc.prccode=T0.profitcode
where T1.project='CLRS' and T1.transtype=30 and CAST (T0.refdate AS datetime) BETWEEN '[%0]' AND '[%1]')g
where g.[Serv Chrgs - CLRS]<>0
how to solve this issue.