找不到对应的关系映射

csy41114

字段什么的 我全对了十几遍。用optional join 有什么注意的么

SELECT MI.* FROM MKT_INBILL MI OPTIONAL JOIN MKT_INBILL_PARENT MIP ON MI.INBILLPARENTID=MIP WHERE MI.SUBPRJID=:SUBPRJID AND MIP.INBILLSTATUS <> '终止'
这么写哪儿不对？？？？？？？？？？？？？
MIP.INBILLSTATUS这个字段对了无数遍数据库



Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT MI.* FROM MKT_INBILL MI OPTIONAL JOIN MKT_INBILL_PARENT MIP ON MI.INBILLPARENTID=MIP WHERE MI.SUBPRJID=:SUBPRJID AND MIP.INBILLSTATUS <> '终止'
--> sql:
--> binds: []
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at CheckInbillAmount.getInBillAmount(CheckInbillAmount.java:54)
        at InCheck.getInCheckAmount(InCheck.java:72)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154038; 提示: MIP.INBILLSTATUS找不到对应的关系映射
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.handleAllRelation(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
        ... 33 more

jishuang

确认MKT_INBILL_PARENT中的INBILLSTATUS这个关系名正确吗？注意分区大小写

csy41114

jishuang 发表于 2017-3-23 11:20
确认MKT_INBILL_PARENT中的INBILLSTATUS这个关系名正确吗？注意分区大小写

已解决