|
版本: |
X5.2.7 |
小版本号: |
|
|
|
数据库: |
Sybase |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Firefox |
|
|
用动用查询数据,要求是第一去重, 第二是去除空的数据,但是报错,查不出来 , 不知道怎么查了, 大家帮忙看看。JUSTEP150210, 执行KSQL出错, KSQL: SELECT DISTINCT TEST_APPLICATION_INFO.pROCESSUNIT as pROCESSUNIT FROM TEST_DETECTION_JCLCJB TEST_DETECTION_JCLCJB optional join TEST_APPLICATION_INFO TEST_APPLICATION_INFO on TEST_DETECTION_JCLCJB = TEST_APPLICATION_INFO.TEST_DETECTION_JCLCJB_ID WHERE (pROCESSUNIT != NULL) LIMIT 0, -1,刷新数据失败!
JUSTEP150210, 执行KSQL出错, KSQL: SELECT DISTINCT TEST_APPLICATION_INFO.pROCESSUNIT as pROCESSUNIT FROM TEST_DETECTION_JCLCJB TEST_DETECTION_JCLCJB optional join TEST_APPLICATION_INFO TEST_APPLICATION_INFO on TEST_DETECTION_JCLCJB = TEST_APPLICATION_INFO.TEST_DETECTION_JCLCJB_ID WHERE (pROCESSUNIT not null) LIMIT 0, -1,刷新数据失败!
JUSTEP150210, 执行KSQL出错, KSQL: SELECT DISTINCT TEST_APPLICATION_INFO.pROCESSUNIT as pROCESSUNIT FROM TEST_DETECTION_JCLCJB TEST_DETECTION_JCLCJB optional join TEST_APPLICATION_INFO TEST_APPLICATION_INFO on TEST_DETECTION_JCLCJB = TEST_APPLICATION_INFO.TEST_DETECTION_JCLCJB_ID WHERE (pROCESSUNIT not null) LIMIT 0, -1,刷新数据失败!
难道不支持 正常的SQL过滤,哪正确的写法又是什么呢???
|
|