我有三个表
teaminfo(表)
字段:
userid,memtotal,teamnameorguser(表)
字段:
userid,departmentidorgdepartment(表)
字段:departmentname,departmentid
产生报表:按部门统计活动(teamname)数
departmentname,count(teamname),memtotal,总金额总金额在表中没有字段,怎么写sql啊
teaminfo(表)
字段:
userid,memtotal,teamnameorguser(表)
字段:
userid,departmentidorgdepartment(表)
字段:departmentname,departmentid
产生报表:按部门统计活动(teamname)数
departmentname,count(teamname),memtotal,总金额总金额在表中没有字段,怎么写sql啊
解决方案 »
- sql server2000 异地备份
- 请问各位大侠,如取表中一字段中相同数据
- 邹建大哥请进!复杂SQL语句,困挠一天了!求!!!!!
- 我安装的sql2005只要是返回表的函数都打不开,请问是怎么回事?
- 100分求助,SQLDMO备份数据库,如何去除备份路径里的空格呢,谢谢~~~~~~~~~~~~~~~~~
- 卖血求一条SQl语句
- 请帮助纠错
- sp_dboption问题
- 用一句sql能update吗?
- 怎样将一个GIF文件,放入MS SQL Server内的binary字段????
- SQLServer2000 链接服务器 用户'sa'登录失败,原因:未与信任SqlServer连接相关联
- 求解决(sql server 2005服务无法启动)
select b.departmentname,count(c.teamname),memtotal
from orguser as a inner join teaminfo as c on a.userid=c.userid inner join orgdepartment as b on a.departmentid=b.departmentid group by b.departmentname,memtotal
我自己写了一条
select a.id,a.departmentname,(select count(distinct x.tname) from bo_teaminfo x join orguser y on y.userid=x.createuser where y.departmentid=a.id) as cnt from orgdepartment a
能够正常运行,但我我再加一个字段时就报错 说什么要加EXISTS
select a.id,a.departmentname,(select count(distinct x.tname),x.memtotal from bo_teaminfo x join orguser y on y.userid=x.createuser where y.departmentid=a.id) from orgdepartment a