select a.id,a.name,sum(b.daf),sum(c.daf),sum(d.daf),sum(e.daf),sum(f.daf), sum(b.daf)+sum(c.daf)+sum(d.daf)+sum(e.daf)+sum(f.daf)from db-2011 a left join db_set b on a.zw=b.val and b.xm='职务' left join db_set c on a.zzmm=b.val and c.xm='政治面貌' left join db_set d on a.whcd=b.val and d.xm='文化程度' left join db_set e on a.jlcf=b.val and e.xm='奖励处分' left join db_set f on a.jldq=b.val and e.xm='艰苦地区' group by a.id,a.name
SQL语句非常简单,什么问题,连接的目的就是将db-2011中的中文转换为DAF
根据楼上的语句,得到的结果,第一列为0,其他列全部为NULL..
贴建表及插入记录的SQL,及要求结果出来看看
修改: select a.id,a.name,sum(b.daf),sum(c.daf),sum(d.daf),sum(e.daf),sum(f.daf), sum(b.daf)+sum(c.daf)+sum(d.daf)+sum(e.daf)+sum(f.daf)from db-2011 a left join db_set b on a.zw=b.val and b.xm='职务' left join db_set c on a.zzmm=c.val and c.xm='政治面貌' left join db_set d on a.whcd=d.val and d.xm='文化程度' left join db_set e on a.jlcf=e.val and e.xm='奖励处分' left join db_set f on a.jldq=f.val and f.xm='艰苦地区' group by a.id,a.name
select a.id,a.name,sum(b.daf),sum(c.daf),sum(d.daf),sum(e.daf),sum(f.daf), sum(b.daf)+sum(c.daf)+sum(d.daf)+sum(e.daf)+sum(f.daf)from db-2011 a left join db_set b on a.zw=b.val and b.xm='职务' left join db_set c on a.zzmm=c.val and c.xm='政治面貌' left join db_set d on a.whcd=d.val and d.xm='文化程度' left join db_set e on a.jlcf=e.val and e.xm='奖励处分' left join db_set f on a.jldq=f.val and e.xm='艰苦地区' group by a.id,a.name
sum(b.daf)+sum(c.daf)+sum(d.daf)+sum(e.daf)+sum(f.daf)from db-2011 a left join db_set b on a.zw=b.val and b.xm='职务'
left join db_set c on a.zzmm=b.val and c.xm='政治面貌'
left join db_set d on a.whcd=b.val and d.xm='文化程度'
left join db_set e on a.jlcf=b.val and e.xm='奖励处分'
left join db_set f on a.jldq=b.val and e.xm='艰苦地区'
group by a.id,a.name
select a.id,a.name,sum(b.daf),sum(c.daf),sum(d.daf),sum(e.daf),sum(f.daf),
sum(b.daf)+sum(c.daf)+sum(d.daf)+sum(e.daf)+sum(f.daf)from db-2011 a
left join db_set b on a.zw=b.val and b.xm='职务'
left join db_set c on a.zzmm=c.val and c.xm='政治面貌'
left join db_set d on a.whcd=d.val and d.xm='文化程度'
left join db_set e on a.jlcf=e.val and e.xm='奖励处分'
left join db_set f on a.jldq=f.val and f.xm='艰苦地区'
group by a.id,a.name
select a.id,a.name,sum(b.daf),sum(c.daf),sum(d.daf),sum(e.daf),sum(f.daf),
sum(b.daf)+sum(c.daf)+sum(d.daf)+sum(e.daf)+sum(f.daf)from db-2011 a left join db_set b on a.zw=b.val and b.xm='职务'
left join db_set c on a.zzmm=c.val and c.xm='政治面貌'
left join db_set d on a.whcd=d.val and d.xm='文化程度'
left join db_set e on a.jlcf=e.val and e.xm='奖励处分'
left join db_set f on a.jldq=f.val and e.xm='艰苦地区'
group by a.id,a.name