6,108
社区成员
发帖
与我相关
我的任务
分享
select a.* ,b.count2 问题数量,c.count3 设备问题,d.count4 人员问题, e.count5 管理问题,nvl(f.count6,0) 重大问题,g.count7 严重问题,l.count8 一般问题, i.count9 监督站及以上,j.count10 厂级,nvl(k.count11,0) 作业区自查自改 from (select t1.departmentname,t2.zgjd,count(*) as count1 from formtable_main_19 t2,hrmdepartment t1 where zgjd=0 and t2.bjdw=t1.id group by departmentname,zgjd ) a left join(select t1.departmentname,count(*) as count2 from formtable_main_19,hrmdepartment t1 where bjdw=t1.id group by departmentname ) b on a.departmentname=b.departmentname left join(select t1.departmentname,t2.wtlb,count(*) as count3 from formtable_main_19 t2,hrmdepartment t1 where wtlb=0 and t2.bjdw=t1.id group by departmentname,wtlb) c on a.departmentname=c.departmentname left join(select t1.departmentname,t2.wtlb,count(*) as count4 from formtable_main_19 t2,hrmdepartment t1 where wtlb=1 and t2.bjdw=t1.id group by departmentname,wtlb) d on a.departmentname=d.departmentname left join(select t1.departmentname,t2.wtlb,count(*) as count5 from formtable_main_19 t2,hrmdepartment t1 where wtlb=2 and t2.bjdw=t1.id group by departmentname,wtlb) e on a.departmentname=e.departmentname left join(select t1.departmentname,t2.yzcd,count(*) as count6 from formtable_main_19 t2,hrmdepartment t1 where yzcd=0 and t2.bjdw=t1.id group by departmentname,yzcd) f on a.departmentname=f.departmentname left join(select t1.departmentname,t2.yzcd,count(*) as count7 from formtable_main_19 t2,hrmdepartment t1 where yzcd=1 and t2.bjdw=t1.id group by departmentname,yzcd) g on a.departmentname=g.departmentname left join(select t1.departmentname,t2.yzcd,count(*) as count8 from formtable_main_19 t2,hrmdepartment t1 where yzcd=2 and t2.bjdw=t1.id group by departmentname,yzcd) l on a.departmentname=l.departmentname left join(select t1.departmentname,t2.wentxz,count(*) as count9 from formtable_main_19 t2,hrmdepartment t1 where wentxz=0 and t2.bjdw=t1.id group by departmentname,wentxz) i on a.departmentname=i.departmentname left join(select t1.departmentname,t2.wentxz,count(*) as count10 from formtable_main_19 t2,hrmdepartment t1 where wentxz=1 and t2.bjdw=t1.id group by departmentname,wentxz) j on a.departmentname=j.departmentname left join(select t1.departmentname,t2.wentxz,count(*) as count11 from formtable_main_19 t2,hrmdepartment t1 where wentxz=2 and t2.bjdw=t1.id group by departmentname,wentxz) k on a.departmentname=k.departmentname