|
版本: |
X5.2.7 |
小版本号: |
|
|
|
数据库: |
MS SQLServer |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
IE10 |
|
|
select A.*,B.sStatusName as sStatusName,B.sActivityName as sAName
from CRM_Movement A
optional join SA_Task B on A.TaskID = B.sID
这样一个查询
运行时提示
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT A.*,B.sStatusName as sStatusName,B.sActivityName as sAName FROM CRM_Movement A optional join SA_Task B on A.TaskID = B.sID WHERE ((((EndTime IS NULL) OR (stringToDate('2014-10-05') <= EndTime)) AND ((StartTime IS NULL) OR (stringToDate('2014-10-12') > StartTime)))) LIMIT 0, 40
编码: JUSTEP154001; 提示: 模块/CRM/Custom/data中, 没有将概念SA_Task映射到数据库
不知啥原因
|
|