17,086
社区成员
发帖
与我相关
我的任务
分享
-- TRY IT ..
UPDATE A
SET X = (SELECT B.V
FROM B
WHERE A.ID = B.ID)
WHERE EXISTS (SELECT 1
FROM B
WHERE A.ID = B.ID);
update a set X=
(select b.v
from b
where a.id = b.id)