场景
要更新的表：t2表
取数表：t1表
一表更新另一表
UPDATE t2
SET t2.fdate = t1.finish_time
FROM T_CN_PAYAPPLY t2
INNER JOIN [GoldLink_Process_Instance] t1 ON t2.FBUSINESS_ID = t1.[business_id]
WHERE t2.fdate >’2024-09-30′
要更新的表：t2表
取数表：t1表
一表更新另一表
UPDATE t2
SET t2.fdate = t1.finish_time
FROM T_CN_PAYAPPLY t2
INNER JOIN [GoldLink_Process_Instance] t1 ON t2.FBUSINESS_ID = t1.[business_id]
WHERE t2.fdate >’2024-09-30′
暂无评论