sql中switch函数无效----QQ已解决，补充最佳

${switch(lx,1,"and id in(--满意
            SELECT a.letterid  FROM
            (SELECT UNITID,LETTERID FROM SLJ_NIBANUNIT where UNITID='"${dw}"') A
            JOIN(SELECT distinct a.SLJID FROM SLJ_EVALUATE a,slj_info b WHERE a.sljid=b.id and a.SAT IN(2,3)
               GROUP BY SLJID)B
            ON A.LETTERID = B.SLJID
                  )",
2,"and id in (--不满意
            SELECT A.letterid FROM
            (SELECT UNITID,LETTERID FROM SLJ_NIBANUNIT where UNITID='"${dw}"') A
            JOIN(SELECT distinct a.SLJID FROM SLJ_EVALUATE a,slj_info b WHERE
               a.sljid=b.id and a.SAT=1
               GROUP BY SLJID)B
               ON A.LETTERID = B.SLJID
)",
）}

这个公式中lx无效

FineReport回音无痕 发布于 2018-7-12 16:03

关注问题

悬赏：2 F币 + 添加悬赏

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

共3回答

最佳回答