户数统计表

select b.名称,
sum(a.光总户数)as 光,
sum(a.力总户数)as 一般工商及其他,
sum(a.水总户数)as 农业生产,
sum(a.非光总户数)as 生活转供,
sum(a.光总户数)+ sum(a.力总户数)+sum(a.水总户数)+sum(a.非光总户数) as 合计
from df_hztqhs a,bs_gdsda b where a.所编号=b.所编号 and 年月='200904' group by b.名称 order by b.名称