更新试图FZJView

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 [打印此页] [关闭]