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

修改視圖

申請免費(fèi)試用、咨詢電話：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:22    編輯：泛普軟件 · xiaona    [打印此頁]    [關(guān)閉]