pgsql 连表更新语法 

UPDATE table_reference t1
SET col_name1 = t2.col_name2
FROM
	table_reference t2
WHERE
	t1.col_name1 = t2.col_name1
posted @ 2024-03-13 11:43  bigroc  阅读(91)  评论(0)  编辑  收藏  举报