mysql 合计行_mysql 行合计问题

selectcol_code,(selectsum(teacher_project_map.col_money)fromteacher_project_mapwhereteacher_project_map.col_code=base_teacher.col_code)assum1,(selectsum(teacher_reward_ma...

select col_code,(select sum(teacher_project_map.col_money) from teacher_project_map where teacher_project_map.col_code=base_teacher.col_code )as sum1,(select sum(teacher_reward_map.col_money) from teacher_reward_map where teacher_reward_map.col_code=base_teacher.col_code )as sum2,(select sum(teacher_paper_map.col_money) from teacher_paper_map where teacher_paper_map.col_code=base_teacher.col_code )as sum3,(select sum(col_money)from teacher_patent_map where teacher_patent_map.col_code=base_teacher.col_code)as sum4,(select sum(col_money) from teacher_standard_map where teacher_standard_map.col_code=base_teacher.col_code)as sum5,(select sum(col_money) from teacher_tachievement_map where teacher_tachievement_map.col_code=base_teacher.col_code)as sum6,(select sum1+sum2+sum3+sum4+sum5+sum6 )as sum7 from base_teacher where col_school = '信息中心' group by base_teacher.col_code

现在想要把sum1+sum2+sum3+sum4+sum5+sum6 每行的结果放到sum7中，我用的是(select sum1+sum2+sum3+sum4+sum5+sum6 )as sum7 结果总是空，如上图所示，跪求大神指点

展开