Navicat 15 for mysql使用sql通过名称列值将两个结果集合并到一起

工具：Navicat 15 for mysql

运行以下sql

select xkx_school.school_name,count(0) allstudentcount from xkx_student left join sys_user on xkx_student.user_id = sys_user.user_id left join xkx_school on xkx_student.dept_id = xkx_school.school_id left join xkx_course on xkx_student.lost_course = xkx_course.course_id group by xkx_school.school_name

此sql结果集为下图

运行以下sql

select xkx_school.school_name,count(0) studentcount from xkx_student left join sys_user on xkx_student.user_id = sys_user.user_id left join xkx_school on xkx_student.dept_id = xkx_school.school_id left join xkx_course on xkx_student.lost_course = xkx_course.course_id where status_id = 2 group by xkx_school.school_name
 此sql结果集为

希望获得如下图所示结果集

求大神指点

不知道你这个问题是否已经解决, 如果还没有解决的话:

• 这篇文章：Navicat for MySQL如何连接数据库以及怎么导入sql文件 也许有你想要的答案，你可以看看

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 以帮助更多的人 ^-^