帆软report中动态拼接SQL语句的问题

大佬们，这个动态拼接sql写法为啥不行：

数据库为PG数据库

select t1.confirm_date,

t1.dept_id,

t1.dept_name,

round(coalesce(t1.cost_amt,0)/10000,1) as cost_amt

FROM ${IF(TYPE == '合同1'," DIV_CON t1 ",

${IF(TYPE == '合同2'," RE_CON t1 ",

${IF(TYPE == '收款1'," DIV_COLL t1 ", " RE_COLL t1 ")}

)}

inner join DEPT ON t1.DEPT_ID = DEPT.CHILD_DEPT_ID

FineReport yzm475374 发布于 2024-11-28 15:06

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共2回答

最佳回答

华莉星宸Lv7资深互助
发布于2024-11-28 15:07

select t1.confirm_date,

t1.dept_id,

t1.dept_name,

round(coalesce(t1.cost_amt,0)/10000,1) as cost_amt

FROM ${IF(TYPE == '合同1'," DIV_CON t1 ", IF(TYPE == '合同2'," RE_CON t1 ", IF(TYPE == '收款1'," DIV_COLL t1 ", " RE_COLL t1 ")))}

inner join DEPT ON t1.DEPT_ID = DEPT.CHILD_DEPT_ID

Z4u3z1Lv6专家互助
发布于2024-11-28 15:08

elect t1.confirm_date,

t1.dept_id,

t1.dept_name,

round(coalesce(t1.cost_amt,0)/10000,1) as cost_amt

FROM ${IF(TYPE == '合同1'," DIV_CON t1 ",

if(TYPE == '合同2'," RE_CON t1 ",

IF(TYPE == '收款1'," DIV_COLL t1 ", " RE_COLL t1 ")))}

inner join DEPT ON t1.DEPT_ID = DEPT.CHILD_DEPT_ID

2关注人数

49浏览人数

最后回答于：2024-11-28 15:08

活动推荐更多

热门课程更多

确定取消