|
查询sql时报这个错,是主键必须再查询条件中吗,但是我想distinct(加上主键就没有效果了)sql:
select distinct TSP_SS_CONFIG_STANDARDCURVE.ORG_ID as ORG_ID,TSP_SS_CONFIG_STANDARDCURVE.ORG_NAME as ORG_NAME,TSP_SS_CONFIG_STANDARDCURVE.UNIT_ID as UNIT_ID,TSP_SS_CONFIG_STANDARDCURVE.UNIT_NAME as UNIT_NAME,TSP_SS_CONFIG_STANDARDCURVE.SS_TYPE_ID as SS_TYPE_ID,TSP_SS_CONFIG_STANDARDCURVE.CURVE_TYPE as CURVE_TYPE,TSP_SS_CONFIG_STANDARDCURVE.CURVE_TYPE_NAME as CURVE_TYPE_NAME,TSP_SS_CONFIG_STANDARDCURVE.FIT_METHOD as FIT_METHOD
from TSP_SS_CONFIG_STANDARDCURVE TSP_SS_CONFIG_STANDARDCURVE
报错信息:com.justep.xbl.runtime.XBLException: 编码: JUSTEP001008; 提示: data[mainData]的idColumn[TSP_SS_CONFIG_STANDARDCURVE]没有在select部分定义
|
|