有两个语句:
select DeptName,COUNT(*) as 入院人数 from I_PatientRegist where TypeState=0 group by DeptName
select DeptName,COUNT(*) as 肺炎人数 from I_PatientRegist where InIcdName like '%肺炎%' group by DeptName
查询结果如下:
目标结果是:
答案如下:
select a.DeptName,isnull(a.入院人数,0) 入院人数,isnull(b.肺炎人数,0) 肺炎人数
from
(select DeptName,COUNT(*) as 入院人数 from I_PatientRegist where TypeState=0 group by DeptName)
A FULL JOIN
(select DeptName,COUNT(*) as 肺炎人数 from I_PatientRegist where InIcdName like '%肺炎%' group by DeptName)
b on a.DeptName=b.DeptName
语法如下:
select 字段列表 from (第一个SQL语句) A FULL JOIN (第二个SQL语句) b on a.字段=b.字段
更多推荐
sql server中将两个SQL语句查询出来的值合并
发布评论