select C.GZ_YM AS 缴费年月, C.C21163 AS 养老保险单位缴纳, C.C2144 AS 养老保险个人缴纳, SUM(C.C21163+C.C2144) AS 养老合计, C.C21165 AS 失业保险单位缴纳, C.C2153 AS 失业保险个人缴纳, SUM(C.C21165+ C.C2153) AS 失业合计, C.C21166 AS 工伤保险单位缴纳, C. C21164 AS 医疗保险单位缴纳, C.C2147 AS 医疗保险个人缴纳, SUM( C.C21164+C.C2147) AS 医疗合计, SUM(C.C21163+C.C21165+ C. C21164+ C.C21166) AS 单位缴纳总合计, SUM(C.C2144+C.C2153+C.C2147) AS 个人缴纳总合计, SUM(C.C21163+C.C21165+ C. C21164+ C.C21166+C.C2144+C.C2153+C.C2147) AS 总合计 FROM C21 C LEFT JOIN b01 on c21.dept_id - b01.dept_id 加GROUP BY
时间: 2024-04-17 12:24:12 浏览: 16
C.GZ_YM AS 缴费年月,
C.C21163 AS 养老保险单位缴纳,
C.C2144 AS 养老保险个人缴纳,
SUM(C.C21163+C.C2144) AS 养老合计,
C.C21165 AS 失业保险单位缴纳,
C.C2153 AS 失业保险个人缴纳,
SUM(C.C21165+ C.C2153) AS 失业合计,
C.C21166 AS 工伤保险单位缴纳,
C. C21164 AS 医疗保险单位缴纳,
C.C2147 AS 医疗保险个人缴纳,
SUM( C.C21164+C.C2147) AS 医疗合计,
SUM(C.C21163+C.C21165+ C. C21164+ C.C21166) AS 单位缴纳总合计,
SUM(C.C2144+C.C2153+C.C2147) AS 个人缴纳总合计,
SUM(C.C21163+C.C21165+ C. C21164+ C.C21166+C.C2144+C.C2153+C.C2147) AS 总合计
FROM C21 C
LEFT JOIN b01 on c21.dept_id - b01.dept_id
GROUP BY C.GZ_YM