UC知道SQL查询的一点小问题~！
来源：百度知道 编辑：UC知道 时间：2024/06/23 04:11:09
我执行如下查询：
SELECT count(*) AS 共计延期笔数 FROM (SELECT TH011,TH012,TH013,TD012,TH014,DATEDIFF(DAY,TD012,TH014)
FROM (SELECT DISTINCT TH011,TH012,TH013,MAX(TH014) AS TH014
FROM PURTH WHERE TH004 LIKE '304%' AND TH014>='20090601'
AND TH014<='20090630' GROUP BY TH011,TH012,TH013) YY
LEFT JOIN PURTD ON TD001=TH011 AND TD002=TH012 AND TD003=TH013 WHERE DATEDIFF(DAY,TD012,TH014)>3) KK
提示
服务器: 消息 8155，级别 16，状态 2，行 1
没有为第 6 列（属于 'KK'）指定列。
请问是怎么回事啊？YY前面（）里单独执行时没有问题
(SELECT TH011,TH012,TH013,TD012,TH014,DATEDIFF(DAY,TD012,TH014)
FROM (SELECT DISTINCT TH011,TH012,TH013,MAX(TH014) AS TH014
FROM PURTH WHERE TH004 LIKE '304%' AND TH014>='20090601'
AND TH014<='20090630' GROUP BY TH011,TH012,TH013)
SELECT count(*) AS 共计延期笔数 FROM (SELECT TH011,TH012,TH013,TD012,TH014,DATEDIFF(DAY,TD012,TH014)
FROM (SELECT DISTINCT TH011,TH012,TH013,MAX(TH014) AS TH014
FROM PURTH WHERE TH004 LIKE '304%' AND TH014>='20090601'
AND TH014<='20090630' GROUP BY TH011,TH012,TH013) YY
LEFT JOIN PURTD ON TD001=TH011 AND TD002=TH012 AND TD003=TH013 WHERE DATEDIFF(DAY,TD012,TH014)>3) KK
提示
服务器: 消息 8155，级别 16，状态 2，行 1
没有为第 6 列（属于 'KK'）指定列。
请问是怎么回事啊？YY前面（）里单独执行时没有问题
(SELECT TH011,TH012,TH013,TD012,TH014,DATEDIFF(DAY,TD012,TH014)
FROM (SELECT DISTINCT TH011,TH012,TH013,MAX(TH014) AS TH014
FROM PURTH WHERE TH004 LIKE '304%' AND TH014>='20090601'
AND TH014<='20090630' GROUP BY TH011,TH012,TH013)
你KK没有定义。不知道你的KK是想做什么。
你PURTD 表中有无TD012,TH014？
如果没有 WHERE DATEDIFF(DAY,TD012,TH014)>3时，
TD012,和TH014从哪里来的，YY中只有TH011,TH012,TH013,TH014 啊