两表关联更新
update a set a.lxryx=b.lxryx
from qyxx as a, qyxx_bak as b
where a.id=b.id
UPDATE table1 SET column1 = table2.column2
FROM table1
JOIN table2 ON table1.join_column = table2.join_column
WHERE condition;
update a set a.lxryx=b.lxryx
from qyxx as a, qyxx_bak as b
where a.id=b.id
UPDATE table1 SET column1 = table2.column2
FROM table1
JOIN table2 ON table1.join_column = table2.join_column
WHERE condition;