是连接表的两个字段别名不一样:累计旷课和累计请假。这样写:SELECT 学号, 班别, 姓名, '累计旷课' AS 类型,Sum(一+二+三+四+五) AS 时间, FROM 课堂旷课汇总表 GROUP BY 学号, 班别, 姓名 UNION ALLSELECT 学号, 班别, 姓名, '累计请假' as 类型,Sum(一+二+三+四+五) AS 时间,FROM 课堂请假汇总表 GROUP BY 学号, 班别, 姓名 或者SELECT 学号, 班别, 姓名, Sum(一+二+三+四+五) AS 累计旷课, 0 AS 累计请假,FROM 课堂旷课汇总表 GROUP BY 学号, ...
|