select a.RegDeptCode,a.RegDeptName,sum(d.RecipeMoney),count(distinct b.RegCode) from Mz_DeptDict a
left join Mz_Registe b on a.RegDeptCode=b.RegDeptCode
left join Mz_RecipeBill c on b.RegCode=c.RegCode
left join Mz_RecipeDetail d on c.RecipeCode=d.RecipeCode
group by a.RegDeptCode,a.RegDeptName
left join Mz_Registe b on a.RegDeptCode=b.RegDeptCode
left join Mz_RecipeBill c on b.RegCode=c.RegCode
left join Mz_RecipeDetail d on c.RecipeCode=d.RecipeCode
group by a.RegDeptCode,a.RegDeptName
解决方案 »
- 新建的SQL实例,服务正常,本地无法连接,求助
- SQL带参数存储过程问题,,急`~~~~~在线等!!
- 帮忙修改自定义函数,该函数用来简化同字段多条件模糊查询,谢谢
- sql 统计问题
- 将.mdf文件导到数据库中?
- 这样的SQL语句怎么写,一个表有多个字段对应另一个表中的同一字段?
- SQL语句、合并两表查询结果(Always online)
- sql server 能否删除我硬盘上的文件呢
- SQL 2000的問題. 急!!!!!!!!
- 急:如何用户Sql70的系统命令实现两个数据库之间的同步
- 请教关于SQL Server触发器问题
- 一个很简单的SQL 语句---------------在线等(急..........)
left join Mz_Registe b on a.RegDeptCode=b.RegDeptCode
left join Mz_RecipeBill c on b.RegCode=c.RegCode
left join Mz_RecipeDetail d on c.RecipeCode=d.RecipeCode
group by a.RegDeptCode,a.RegDeptName
,RecipeMoney=sum(d.RecipeMoney),人次=count(distinct b.RegCode)
from Mz_DeptDict a
join Mz_Registe b on a.RegDeptCode=b.RegDeptCode
join Mz_RecipeBill c on b.RegCode=c.RegCode
join Mz_RecipeDetail d on c.RecipeCode=d.RecipeCode
group by a.RegDeptCode,a.RegDeptName
select sum(d.RecipeMoney),count(distinct RegCode)
from Mz_DeptDict a left join
Mz_Registe b on a.RegDeptCode=b.RegDeptCode left join
Mz_RecipeBill c on b.RegCode=c.RegCode left join
Mz_RecipeDetail d on c.RecipeCode=d.RecipeCode
group by a.RegDeptCode,a.RegDeptName