select A.*,B.kslbfl,B.kspx,B.ks from T1_kspx B left join (
SELECT Ks as ksl,
sum(case wzfl when '办公用品' then ckje else 0 end)as bgyp,
sum(case wzfl when '印刷用品' then ckje else 0 end)as ysyp,
qtckje=sum(case wzfl when '清洁用品' then ckje else 0 end)+sum(case wzfl when '基建维修材料' then ckje else 0 end)+sum(case wzfl when '其它' then ckje else 0 end)+sum(case wzfl when '日用品' then ckje else 0 end),
sum(case wzfl when '氧气' then ckje else 0 end)as yq,
sum(case wzfl when '缝纫' then ckje else 0 end)as fr,
sum(case wzfl when '蒸汽费' then ckje else 0 end)as zqf,
sum(case wzfl when '洗衣费' then ckje else 0 end)as xyf,
sum(case wzfl when '维修费' then ckje else 0 end)as wxf
FROM V2_wz_Dbddjmx
Group By ks) A on A.ksl=B.ks
order by kslbfl