【高频问题】NC65，后台查询科目余额表。

select org_accountingbook.code 账簿编码, org_accountingbook.name 账簿名称, bd_accasoa.dispname 科目名称, bd_account.code 科目编码, sum(case when adjustperiod=‘00‘ then gl_detail.localdebitamount else 0 end) “期初借方“, sum(case when adjustperiod=‘00‘ then gl_detail.localcreditamount else 0 end) “期初贷方“, sum(case when adjustperiod=‘12‘ then gl_detail.localdebitamount else 0 end) “借方发生“, sum(case when adjustperiod=‘12‘ then gl_detail.localcreditamount else 0 end) “贷方发生“, sum(case when adjustperiod>‘00‘ and adjustperiod<=‘12‘ then gl_detail.localdebitamount else 0 end) “借方累计“, sum(case when adjustperiod>‘00‘ and adjustperiod<=‘12‘ then gl_detail.localcreditamount else 0 end) “贷方累计“, sum(case when adjustperiod<=‘12‘ then gl_detail.localdebitamount else 0 end) “借方期末“, sum(case when adjustperiod<=‘12‘ then gl_detail.localcreditamount else 0 end) “贷方期末“ from gl_detail gl_detail,org_accountingbook,bd_accasoa,bd_account where gl_deta