请问,做了一个Oracle SQL脚本,在PLSQL里能够正确执行,在5.5里确执行不了报错,请问是什么原因呢? 错误代码:62400001LogLabel 29[SqlJDBCExecuteTemplate] 脚本如下 select org_orgs.code, org_orgs.name, bd_accasoa.name, bd_currtype.name, tab.qmye from (SELECT a.PK_ACCOUNTINGBOOK, a.PK_ACCASOA, a.PK_CURRTYPE, ((nvl(a.QCJF, 0) - nvl(a.QCDF, 0)) + nvl(b.FSJF, 0) - nvl(b.FSDF, 0)) as qmye FROM (SELECT DISTINCT gl_balan.pk_accountingbook, gl_balan.pk_accasoa, gl_balan.pk_currtype, sum(gl_balan.debitamount) as qcjf, sum(gl_balan.creditamount) as qcdf FROM gl_balance gl_balan WHERE gl_balan.year = '2021' AND gl_balan.adjustperiod >= '00' AND gl_balan.adjustperiod < '01' AND gl_balan.voucherkind <> 5 AND gl_balan.pk_accasoa IN (select pk_accasoa from bd_accasoa where dispname in ('1001\库存现金', '1002\银行存款')) GROUP BY gl_balan.pk_accountingbook, gl_balan.pk_accasoa, gl_balan.pk_currtype) a LEFT JOIN (SELECT gl_detail.pk_accountingbook, gl_detail.pk_accasoa, gl_detail.pk_currtype, sum(gl_detail.debitamount) as fsjf, sum(gl_detail.creditamount) as fsdf FROM gl_detail gl_detail WHERE gl_detail.pk_accasoa IN (select pk_accasoa from bd_accasoa where dispname in ('1001\库存现金', '1002\银行存款')) AND gl_detail.yearv = '2021' AND gl_detail.adjustperiod >= '01' AND gl_detail.adjustperiod <= '02' AND gl_detail.dr = 0 AND gl_detail.discardflagv <> 'Y' AND gl_detail.voucherkindv <> 255 AND gl_detail.tempsaveflag <> 'Y' AND gl_detail.pk_managerv = 'N/A' AND gl_detail.voucherkindv <> 5 GROUP BY gl_detail.pk_accountingbook, gl_detail.pk_accasoa, gl_detail.pk_currtype) b ON a.PK_ACCOUNTINGBOOK = b.PK_ACCOUNTINGBOOK AND a.PK_ACCASOA = b.PK_ACCASOA AND a.PK_CURRTYPE = b.PK_CURRTYPE) tab left join org_accountingbook on tab.pk_accountingbook = org_accountingbook.pk_accountingbook join bd_accasoa on tab.pk_accasoa = bd_accasoa.pk_accasoa join bd_currtype on tab.pk_currtype = bd_currtype.pk_currtype join org_orgs on org_accountingbook.pk_relorg = org_orgs.pk_org |
最佳回答 |
||||
0
|
|