标签: 连表更新语法

pgsql 连表更新语法

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