查询表t_local_warning_hit_sourcesend_time 更新到表t_local_warning_source

WITH t2 AS ( SELECT ID, send_time FROM t_local_warning_hit_source WHERE send_time &gt;= '2023-09-27 00:00:00' AND send_time < '2023-11-28 00:00:00' ) 
UPDATE t_local_warning_source ts 
SET send_time = t2.send_time 
FROM
	t2 
WHERE
	ts.hit_source_id = t2.ID

在这里插入图片描述

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注