外教和积分更新字段
外教和积分更新字段 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
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
相关栏目：
相关文章：
- 1ERP应用成功的标志
- 2培训学校管理系统能有什么帮助?
- 3解决SQL数据库日志已满的问题
- 4MD5算法的安全性
- 5少儿英语培训软件特点
- 6培训学校客户普遍担心的问题。
- 7转班操作
- 8-创建视图 NewsView
- 92015年元旦放假通知
- 10培训学校价格优惠中
- 11通知 各项目组注意：
- 12定向开发需求
- 13市场主管
- 14培训学校管理软件更新学习视频
- 15培训学校管理软件寻项目合作
- 16商道即人道
- 17买软件就是买服务
- 18如何去选择软件开发公司
- 192012五一放假安排
- 20怎么清除数据日志
- 21培训机构管理系统优势有哪些
- 22做企业管理软件的公司如何赚钱?
- 23培训学校定制开发流程
- 24培训学校管理系统-继续教育培训管理系统
- 25招生顾问采集的学生信息导入问题
- 26公司今年推出云主机服务。
- 27诊断企业信息化杂症之ERP之痛
- 28软件开发的优点
- 29CREATE TABLE [dbo].[DFFPRecord](
- 30灵活的权限控制
上一篇：学校管理软件财务管理
下一篇：请把自己的操作流程说清楚
相关系统
联系方式
成都公司：成都市成华区建设南路160号1层9号
重庆公司：重庆市江北区红旗河沟华创商务大厦18楼
