请问为什么查不出数据来

想查询两个数据相减的结果，但是数据读不出来，一直显示正在加载数据请问这是什么原因？

代码如下

select a.bic_mzxnjg,a.mmzecfl1,a.khfl1_txt,a.mmzecfl2,a.khfl2_txt,a.mmm_ypdl,a.mmmbwcs2,a.jsl-b.jhl as kcl from

(SELECT bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2,sum(msdjsqty)/count(doc_num) AS jsl,sum(subtot_oc1)/count(doc_num)AS jsje from app_yc.yc_kcl_orc

where jsdat <= '${tjdate}' /*结算前台查询日期示例， '2022-12-20'*/

GROUP BY bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2

)a,

(SELECT bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2,sum(nvl(act_dl_qty,0)) AS jhl from app_yc.yc_kcl_orc

where jsdat <= '${tjdate}' and jhdat <= '${tjdate}'/*交货前台查询日期示例， '2022-12-20'*/

GROUP BY bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2

FineReport 用户x076327 发布于 2022-12-29 16:09 （编辑于 2022-12-29 16:18）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

Z4u3z1Lv6专家互助
发布于2022-12-29 16:23

select a.bic_mzxnjg,a.mmzecfl1,a.khfl1_txt,a.mmzecfl2,a.khfl2_txt,a.mmm_ypdl,a.mmmbwcs2,a.jsl-b.jhl as kcl from

(SELECT bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2,sum(msdjsqty)/count(doc_num) AS jsl,sum(subtot_oc1)/count(doc_num)AS jsje from app_yc.yc_kcl_orc

where jsdat <= '${tjdate}' /*结算前台查询日期示例， '2022-12-20'*/

GROUP BY bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2

)a inner JOIN

(SELECT bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2,sum(nvl(act_dl_qty,0)) AS jhl from app_yc.yc_kcl_orc

where jsdat <= '${tjdate}' and jhdat <= '${tjdate}'/*交货前台查询日期示例， '2022-12-20'*/

GROUP BY bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2

)b ON A.bic_mzxnjg=b.bic_mzxnjg AND A.mmzecfl1=B.mmzecfl1 AND A.khfl1_txt=B.khfl1_txt AND A.mmzecfl2=B.mmzecfl2 AND A.khfl2_txt=B.khfl2_txt AND A.mmm_ypdl=B.mmm_ypdl AND A.mmmbwcs2=B.mmmbwcs2