Привет Всем! Такой вот случай (непонятный для меня ).Имеется запрос:
select 'ВСЕГО'
,(select count(tk1.cstdate) from yeis.kontracts tk1 where tk1.mfo=tk.mfo ) as dras
,(select sum(case when tagrm.agrmsum=0 or tagrm.agrmsum is null then tk2.kntsum*tk2.currrate_c else tagrm.agrmsum*tagrm.currrate end)
from yeis.kontracts tk2 left outer join (select * from YEIS.Agrmnts TAgrm where TAgrm.AgrmNo=(select max(TAgrm1.AgrmNo)
from YEIS.Agrmnts TAgrm1 where TAgrm1.KntID=TAgrm.KntID)) as TAgrm on TK2.KntID=TAgrm.KntID where tk2.mfo=tk.mfo) as gdsName
,count(TD.DlvDate) as dlvdate
,(select sum(tpf.pmsum*tcr.currrate/tcr.currcount) as SUMTPf from yeis.paymfact tpf inner join yeis.currrate tcr on tcr.kod=tpf.currkod
inner join yeis.kontracts tk4 on tk4.kntid=tpf.kntid where tcr.chdate= (select max(tcr1.chdate) from yeis.currrate tcr1
where tcr1.kod=tcr.kod and sign(tpf.pmdate-tcr1.chdate)>=0) and tcr.currcount<>0 and tk4.mfo=tk.mfo) as receipts
,(select sum(TCSl.PmSum*TCSl.CurrRate/TCSl.CurrCount) as SUMTCSl from YEIS.CurrSale TCSl inner join yeis.kontracts tk5 on tcsl.kntid=tk5.kntid
where TCSl.CurrCount<>0 and tk5.mfo=tk.mfo) as sUMTCSl
,count(TD.BoardDate) as arrivalgoods
,(select sum(TOp.C_Oplat*tk6.currrate_r) from YEIS.Oplata TOp
inner join yeis.kontracts tk6 on tk6.kntid=top.kntid where tk6.mfo=tk.mfo) as dlvTrm
,sum(case when UCASE(TK.KntType)='ИМ' then TD.InvCost*TK.CurrRate_c else 0 end)-(select sum(TOp.C_Oplat*tk6.currrate_r)
from YEIS.Oplata TOp inner join yeis.kontracts tk6 on tk6.kntid=top.kntid
where tk6.mfo=tk.mfo and ucase(tk6.knttype)='ИМ') as debtor
,sum(case when UCASE(TK.KntType)='ЭК' then TD.InvCost*TK.CurrRate_c else 0 end)-(select sum(TOp.C_Oplat*tk6.currrate_r)
from YEIS.Oplata TOp inner join yeis.kontracts tk6 on tk6.kntid=top.kntid
where tk6.mfo=tk.mfo and ucase(tk6.knttype)='ЭК') as kreditor
,(select count(tsr.dzakr) from yeis.srok tsr inner join yeis.kontracts tk7 on tk7.kntid=tsr.kntid
where tk7.mfo=tk.mfo) as contrtakenout
from YEIS.Kontracts TK left outer join YEIS.Deliver TD on TD.KntID=TK.KntID
where TK.MFO=00914 group by tk.mfo

При его компиляции выдает сообщение Error: java.sql.SQLException: [SQL0901] SQL system error., SQL State: 58004, Error Code: -901
Работаю в squirrel client2.5
Не пойму в чем проблема...