修改视图

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

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