22,207
社区成员
发帖
与我相关
我的任务
分享
--查询
select isnull(b.ysks,'妇产科') as ysks ,isnull(b.czfl,a.czfl) as czfl,isnull(b.ypje,0) as ypje ,a.ysks,a.czfl,a.ypje,
isnull(c.ysks,'XXXX科') as ysks ,isnull(c.czfl,a.czfl) as czfl,isnull(c.ypje,0) as ypje
from
(
select ysks,czfl,sum(ypje) as ypje from #tab where ysks='骨外二区' Group by ysks,czfl
) a left join
(
select ysks,czfl,sum(ypje) as ypje from #tab where ysks='妇产科' Group by ysks,czfl
) b on a.czfl=b.czfl
left join
(
select ysks,czfl,sum(ypje) as ypje from #tab where ysks='XXXX科' Group by ysks,czfl
)c on a.czfl=c.czfl