未到访学生语句修改代码

SELECT dbo.Clue.uClu_ID, dbo.Clue.cClu_CName, dbo.Clue.iClu_Age AS 年龄, dbo.Clue.cClu_Phone, TMKRecord.cTMKR_Intention AS 意向状态, TMKRecord.dTMKR_ContactTime AS 上次联系时间,

TMKRecord.cUser_Name AS TMK, dbo.Clue.dClu_CreateTime, dbo.Channel.cCha_Name AS 渠道, dbo.Clue.cClu_HFRY, dbo.ExtensionWorkers.cExtW_Num AS 推广人员, dbo.Clue.cClu_KCGW,

dbo.Clue.dClu_DFZTChangeTime AS 到访状态更改时间, dbo.Clue.cClu_State

FROM dbo.Clue LEFT OUTER JOIN

dbo.StudentBelongs ON dbo.StudentBelongs.uStuB_ID = dbo.Clue.uClu_StuBId LEFT OUTER JOIN

dbo.Grade ON dbo.Grade.uGra_ID = dbo.Clue.uClu_GraId LEFT OUTER JOIN

dbo.ExtensionWorkers ON dbo.ExtensionWorkers.uExtW_ID = dbo.Clue.uClu_ExtWId LEFT OUTER JOIN

dbo.TSource ON dbo.TSource.uTS_ID = dbo.Clue.uClu_TOUTId LEFT OUTER JOIN

dbo.Channel ON dbo.Channel.uCha_ID = dbo.Clue.uClu_ChaId LEFT OUTER JOIN

(SELECT TMKRecord_1.uTMKR_CluId, MAX(TMKRecord_1.cTMKR_Intention) AS cTMKR_Intention, MAX(TMKRecord_1.dTMKR_ContactTime) AS dTMKR_ContactTime, COUNT(*) AS TMKCount,

MAX(dbo.[User].cUser_Name) AS cUser_Name

FROM dbo.TMKRecord AS TMKRecord_1 LEFT OUTER JOIN

dbo.[User] ON TMKRecord_1.uTMKR_TMKId = dbo.[User].uUser_ID

GROUP BY TMKRecord_1.uTMKR_CluId) AS TMKRecord ON TMKRecord.uTMKR_CluId = dbo.Clue.uClu_ID

WHERE (dbo.Clue.cClu_State <> '未到访')

发布：2007-03-30 10:26 编辑：泛普软件 · xiaona [打印此页] [关闭]