34,590
社区成员
发帖
与我相关
我的任务
分享
UPDATE b
SET b.bc2 = a.bc ,
b.blb = a.blb
FROM 调班表 AS a
INNER JOIN 考勤表 as b ON a.ny = b.ny
AND a.xm = b.xm
WHERE b.ny = @ny
AND a.rq1=(SELECT TOP 1 rq1 FROM 调班表 WHERE ny=b.ny AND xm=b.xm AND b.rq>=rq1 AND b.rq<=rq2 ORDER BY rq1 desc)