更新TABLE2的NAME到,TABLE1表的NAME字段。
update TABLE1 A
set A.NAME = (SELECT B.NAME
FROM TABLE2 B
WHERE A.ID = B.ID)
WHERE EXISTS (SELECT B.NAME
FROM TABLE2 B
WHERE A.ID = B.ID)
update TABLE1 A
set A.NAME = (SELECT B.NAME
FROM TABLE2 B
WHERE A.ID = B.ID)
WHERE EXISTS (SELECT B.NAME
FROM TABLE2 B
WHERE A.ID = B.ID)