查询3怎样才能做成效果图的结果

点击下载此附件SELECT Max(t.月份) AS 月份之最大值, t.相关人, Max(t.内部原因) AS 内部原因之最大值, Max(t.外部原因) AS 外部原因之最大值, Sum(t.内部奖惩) AS 内部, Sum(t.外部奖惩) AS 外部
FROM [SELECT 月份,相关人,内部原因 ,"" AS 外部原因,内部奖惩,null as 外部奖惩 FROM 合并字段1
UNION ALL
SELECT 月份,相关人,"" as 内部原因, 外部原因 ,null as  内部奖惩, 外部奖惩 FROM 合并字段2]. AS t
GROUP BY t.相关人;