監(jiān)理公司管理系統(tǒng) | 工程企業(yè)管理系統(tǒng) | OA系統(tǒng) | ERP系統(tǒng) | 造價咨詢管理系統(tǒng) | 工程設(shè)計管理系統(tǒng) | 甲方項目管理系統(tǒng) | 簽約案例 | 客戶案例 | 在線試用
X 關(guān)閉

外教和積分更新字段

申請免費試用、咨詢電話：400-8352-114

    外教和積分更新字段 SELECT DISTINCT
                      c.uClu_ID AS uStu_ID, c.cClu_Num AS cStu_Num, c.cClu_CName AS cStu_CName, c.cClu_EName AS cStu_EName, c.iClu_Age AS cStu_Age,
                      cou.cCou_BJ AS cStu_Class, cou.cCou_JSH AS cStu_ClassNum, cou.cCou_JB AS cStu_ClassType, c.cClu_XXZT AS sStu_XXZT, cou.cCou_XQ AS cStu_ClassTime,
                      c.cClu_Phone AS sStu_Phone, dbo.[User].cUser_Name AS cStu_CE, EAUser.cUser_Name AS 外教老師, c.cClu_KCGW, ISNULL(J.s, 0) AS 積分,
                      c.dClu_CreateTime AS dStu_CreateTime
FROM         dbo.Clue AS c INNER JOIN
                      dbo.Charge ON c.uClu_ID = dbo.Charge.uCha_CluId LEFT OUTER JOIN
                      dbo.Clue_Course AS cc ON c.uClu_ID = cc.uCluCou_CluId LEFT OUTER JOIN
                      dbo.Course AS cou ON cou.uCou_ClasID = cc.uCluCou_CouId LEFT OUTER JOIN
                      dbo.[User] AS EAUser ON EAUser.uUser_ID = cou.uCou_WStaffId LEFT OUTER JOIN
                      dbo.[User] ON dbo.[User].uUser_ID = cou.uCou_StaffId LEFT OUTER JOIN
                          (SELECT     uJF_CLuId, SUM(iJF_num) AS s
                            FROM          dbo.JF
                            GROUP BY uJF_CLuId) AS J ON J.uJF_CLuId = c.uClu_ID
發(fā)布：2007-03-30 10:26    編輯：泛普軟件 · xiaona    [打印此頁]    [關(guān)閉]