pgsql 连表更新语法

UPDATE table_reference t1
SET col_name1 = t2.col_name2
FROM
	table_reference t2
WHERE
	t1.col_name1 = t2.col_name1