67,513
社区成员
发帖
与我相关
我的任务
分享sql代码缺失右括号
sb.append("select MCHT_NO,MCHT_NM,LICENCE_NO,APPLY_DATE,MAPPING_MCHNTCDONE,MAPPING_MCHNTCDTW O,MCHT_STATUS,TERM_COUNT from ");
sb.append("((SELECT * FROM TBL_MCHT_BASE_INF_TMP t1 left outer join TBL_BRH_INFO t2 on t2.brh_id=t1.agr_br ) A left outer join (select MCHT_CD,count(1) AS TERM_COUNT from TBL_TERM_INF group by MCHT_CD) B ON (A.MCHT_NO = B.MCHT_CD))");
sb.append("where MCHT_STATUS IN ('1','3','5','6','8','R') ");
运行的时候显示上述代码缺失右括号，但是在数据库中可以运行出来，这是什么原因
sb.append("((SELECT * FROM TBL_MCHT_BASE_INF_TMP t1 left outer join TBL_BRH_INFO t2 on t2.brh_id=t1.agr_br ) A left outer join (select MCHT_CD,count(1) AS TERM_COUNT from TBL_TERM_INF group by MCHT_CD) B ON (A.MCHT_NO = B.MCHT_CD))");
sb.append("where MCHT_STATUS IN ('1','3','5','6','8','R') ");
运行的时候显示上述代码缺失右括号，但是在数据库中可以运行出来，这是什么原因
...全文
请发表友善的回复…
发表回复
minftsc_1994 2017-11-28
- 打赏
- 举报
可以一部分一部分运行试试，知道是哪里出的错，然后就好办了
Exception e 2017-07-20
- 打赏
- 举报
直接把sql打出来，然后就很直观
minemine0418 2017-07-19
- 打赏
- 举报
(
SELECT * FROM TBL_MCHT_BASE_INF_TMP t1
left outer join TBL_BRH_INFO t2 on t2.brh_id=t1.agr_br A left outer join
(
select MCHT_CD,count(1) AS TERM_COUNT from TBL_TERM_INF group by MCHT_CD
) B ON A.MCHT_NO = B.MCHT_CD
)
这样试试？
qq_35942223 2017-07-19
- 打赏
- 举报
你控制台toString()打印一下
