复制一个表的其中两个字段到另一个表中对应的相同字段
话不多说,直接上代码
update tbl_norm n set (n.ADDRESS_AREA, n.ADDRESS) = (
select m.ADDRESS_AREA, m.ADDRESS from (
select ID, ADDRESS_AREA, ADDRESS from tbl_info group by ID, ADDRESS_AREA, ADDRESS
) m where m.ID= n.ID
);
话不多说,直接上代码
update tbl_norm n set (n.ADDRESS_AREA, n.ADDRESS) = (
select m.ADDRESS_AREA, m.ADDRESS from (
select ID, ADDRESS_AREA, ADDRESS from tbl_info group by ID, ADDRESS_AREA, ADDRESS
) m where m.ID= n.ID
);