ksql.select怎么多表关联查询

nothing332311

ksql.select怎么多表关联查询

jishuang

http://bbs.wex5.com/forum.php?mod=viewthread&tid=37258

nothing332311

jishuang 发表于 2018-11-26 14:07
http://bbs.wex5.com/forum.php?mod=viewthread&tid=37258

Caused by: com.justep.exception.KSQLException: 编码: JUSTEP154115; 提示: KSQL语法错误, fFSuissionData ^^) )中未找到需要的元素, 位置55期望是(
        at com.justep.exception.KSQLException.create(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
        at com.justep.system.ksql.token.TokenManager.matched(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.constExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
        ... 57 more

nothing332311

jishuang 发表于 2018-11-26 14:07
http://bbs.wex5.com/forum.php?mod=viewthread&tid=37258

String ksql = "select Wl_businessapplication.*,Wl_customerinfo.* "+
                                          "from Wl_businessapplication Wl_businessapplication "+
                                          "optional join Wl_customerinfo Wl_customerinfo on Wl_customerinfo.fCustomerinfoParentlink = Wl_businessapplication " +
                                          "where Wl_businessapplication.fFDApprovalState = '2' and Wl_customerinfo.fDataToBankDate is null " +
                                          "AND :dateDiff('dd',:currentDate() , :toDate( fFSuissionData ) ) = 1";
                Table table = KSQL.select(ksql, null, "/WL/common/data", null);
                Iterator<Row> rows=table.iterator();
                Row row = rows.next();

nothing332311

jishuang 发表于 2018-11-26 14:07
http://bbs.wex5.com/forum.php?mod=viewthread&tid=37258

:toDate( Wl_businessapplication.fFSuissionData )的话报错
KSQL语法错误, nessapplication^^.fFSuissionData中未找到需要的元素, 位置62期望是(

nothing332311

jishuang 发表于 2018-11-26 14:07
http://bbs.wex5.com/forum.php?mod=viewthread&tid=37258

我换了其他任何一个字段都会报错编码: JUSTEP154115; 提示: KSQL语法错误, nessapplication^^.fBusinessDate 中未找到需要的元素, 位置62期望是(

jishuang

确认是不是两个里面都有fBusinessDate ，把其中一个as一个别名

nothing332311

jishuang 发表于 2018-11-26 16:17
确认是不是两个里面都有fBusinessDate ，把其中一个as一个别名

最后面这一行我用java代码来判断了,没用sql了,结贴吧