同样的一个句子，在两个表里，一个能用，一个不能用
有两个表 SOLODATA和UNDOSOLODATA
操作UNDOSOLODATA
SELECT '' AS EQUIPEMENT, UNDOSOLODATA.TAGNUMBER AS SOLODATA_TAGNUMBER, Count(SOLODATA_TAGNUMBER) AS UNDOSOLODATA_TAGNUMBER,'' AS UNDOSOLODATA_REMARK11,'' AS UNDOSOLODATA_STARTDATE11,SUM(DATEDIFF("D", UNDOSOLODATA.STARTDATE11, UNDOSOLODATA.ENDDATE11)) AS UNDOSOLODATA_ENDDATE11, '' AS TOTAL
FROM COMPONENT_GROUPIDS INNER JOIN UNDOSOLODATA ON COMPONENT_GROUPIDS.[GROUPID] = UNDOSOLODATA.[GROUPID]
GROUP BY UNDOSOLODATA.TAGNUMBER HAVING Count(*)>=1
这个句子就能执行
操作SOLODATA
SELECT '' AS EQUIPEMENT, SOLODATA.TAGNUMBER AS SOLODATA_TAGNUMBER, Count(SOLODATA_TAGNUMBER) AS UNDOSOLODATA_TAGNUMBER,'' AS UNDOSOLODATA_REMARK11,'' AS UNDOSOLODATA_STARTDATE11,SUM(DATEDIFF("D", SOLODATA.STARTDATE11, SOLODATA.ENDDATE11)) AS UNDOSOLODATA_ENDDATE11, '' AS TOTAL
FROM COMPONENT_GROUPIDS INNER JOIN SOLODATA ON COMPONENT_GROUPIDS.[GROUPID] = SOLODATA.[GROUPID]
GROUP BY SOLODATA.TAGNUMBER HAVING Count(*)>=1
这个句子就不能执行
显示错误 表达的标准数据类型不匹配
我检查了下问题在SOLODATA.STARTDATE11, SOLODATA.ENDDATE11全换成date()，程序就能运行。
所以我去查了下SOLODATA.STARTDATE11, SOLODATA.ENDDATE11的类型，为text，和UNDOSOLODATA.STARTDATE11, UNDOSOLODATA.ENDDATE11一样，那么为什么操作SOLODATA表时就有问题呢？请大家指点下
我觉得可能是类型问题，但是检查了下类型都是一样的，还有没有可能是其他问题呢？谢谢
SOLODATA.STARTDATE11, SOLODATA.ENDDATE11
检查这两个，应该是有不符合日期格式的。