sql 语句问题

1104797209

SELECT SA_OPOrg.* FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND (SA_OPOrg.SORGKINDID = 'ogn') ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20;





这个orgdata用来做下拉数据的，页面报这个错误，

JUSTEP150210, 执行KSQL出错, KSQL: SELECT SA_OPOrg.* FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.SORGKINDID = 'ogn')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20,刷新数据失败！ 详细

确定

编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT SA_OPOrg.* FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.SORGKINDID = 'ogn')) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20 编码: JUSTEP154038; 提示: SA_OPOrg.SORGKINDID找不到对应的关系映射 java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.justep.system.action.Engine.invokeActions(Native Method) at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source

1104797209

在数据库里运行这个语句，显示的错误是，命令未正确结束

1104797209

结帖吧，找到问题了