Skip to Content
0
Former Member
Jul 02, 2009 at 12:43 PM

Error : [Microsoft SQL] [SQL Native client][SQL Server] Must specify table

804 Views

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.