${if("${ZT}"="不包含","withZDHCas(selectTYBI5_T_YJS_ZY_XMJLTB.xmbh,TYBI5_T_YJS_ZY_XMJLTB.zxmc,TYBI5_T_YJS_ZY_XMJLTB.zYmc,TYBI5_T_YJS_ZY_XMJLTB.YSZEfrom TYBI5_T_YJS_ZY_XMJLTB inner join (select xmbh,zxmc,zymc,max(jshc) as jshc from TYBI5_T_YJS_ZY_XMJLTB group by xmbh,zxmc,zymc) maxon TYBI5_T_YJS_ZY_XMJLTB.XMBH=max.xmbhand TYBI5_T_YJS_ZY_XMJLTB.zxmc=max.zxmcand TYBI5_T_YJS_ZY_XMJLTB.zymc=max.zymcand TYBI5_T_YJS_ZY_XMJLTB.jshc=max.jshcwhere 1=1and TYBI5_T_YJS_ZY_XMJLTB.xmbh=${XMBH}) ,sjjgas(selectTYBI5_W_YJSJG_ZY.xmbh,TYBI5_W_YJSJG_ZY.zxmc,TYBI5_W_YJSJG_ZY.zymc,TYBI5_W_YJSJG_ZY.ZYYSZEfrom TYBI5_W_YJSJG_ZY inner join ( select xmbh,max(jsbm) as jsbm from TYBI5_W_YJSJG_ZY group by xmbh) maxon TYBI5_W_YJSJG_ZY.XMBH=max.xmbhand TYBI5_W_YJSJG_ZY.jsbm=max.jsbmwhere 1=1and TYBI5_W_YJSJG_ZY.xmbh=${XMBH}) --select * from sjjgselect case when a.xmbh is null then b.xmbh else a.xmbh end AS 项目编号,case when a.zxmc is null then b.zxmc else a.zxmc end AS 子项名称,case when a.zymc is null then b.zymc else a.zymc end AS 专业名称,nvl(case when a.ysze is null then b.ZYYSZE else a.ysze end,0) AS 预算额--nvl(a.DQJSE,0) AS 结算额from sjjg bleft join ZDHC aon a.xmbh=b.xmbhand a.zxmc=b.zxmcand a.zYmc=b.zYmc","withhcas(selectxmbh,JSBM,max(JSHC) as jshcfrom TYBI5_T_YJS_ZY_XMJLTBwhere 1=1 and TYBI5_T_YJS_ZY_XMJLTB.xmbh=${XMBH}group by xmbh,JSBM) ,HUIZONGAS( SELECT JSHC,子项名称,专业名称,预算分配原值,当前结算分配原值FROM(select TYBI5_T_YJS_ZY_XMJLTB.zxmc as 子项名称,TYBI5_T_YJS_ZY_XMJLTB.zymc as 专业名称,TYBI5_T_YJS_ZY_XMJLTB.JSHC,TYBI5_T_YJS_ZY_XMJLTB.YSZE as 预算分配原值,TYBI5_T_YJS_ZY_XMJLTB.DQJSE as 当前结算分配原值 from TYBI5_T_YJS_ZY_XMJLTB inner join hc on TYBI5_T_YJS_ZY_XMJLTB.xmbh=hc.XMBH and TYBI5_T_YJS_ZY_XMJLTB.JSBM=hc.JSBM where 1=1 and TYBI5_T_YJS_ZY_XMJLTB.xmbh=${XMBH} AND TYBI5_T_YJS_ZY_XMJLTB.JSHC <= (selectmax(JSHC) as jshcfrom TYBI5_T_YJS_ZY_XMJLTBwhere 1=1 and TYBI5_T_YJS_ZY_XMJLTB.xmbh=${XMBH}) AND TYBI5_T_YJS_ZY_XMJLTB.SJZT='1'))select 子项名称,专业名称,预算分配原值,当前结算分配原值from HUIZONG WHERE HUIZONG.JSHC=(SELECT MAX(HUIZONG.JSHC) FROM HUIZONG)")}数据集内能不能这么做流程判断？ 这么写 预览sql没用 不做判断
