34,590
社区成员
发帖
与我相关
我的任务
分享
select CONVERT(varchar(6),日期,112) as [日期],SUM(考勤工资)
from 表1
left join
表2 on 表1.职工号=表2.职工号
group by CONVERT(varchar(6),日期,112)
select 职工号,CONVERT(varchar(6),日期,112) as [日期],SUM(考勤工资) from 表1 left join
表2 on 表1.职工号=表2.职工号
group by 职工号,CONVERT(varchar(6),日期,112)
SELECT * FROM [表2] inner join (SELECT [职工号],SUM([考勤工资]) 考勤工资
from [表1] where DATEPART(M,[日期])=5 GROUP BY 职工号 ) a
WHERE [表2].[职工号]=a.[职工号]
SELECT * FROM 表2 inner join (SELECT 职工号,SUM(考勤工资) 考勤工资
from 表1
where DATEPART(M,日期)=5 GROUP BY 职工号 )