--a, b具有相同的code, 将a.name值, 全部更新为 b.NAME值
UPDATE a SET a.NAME =
(SELECT b.NAME FROM b WHERE b.code = a.code)
WHERE EXISTS (SELECT 1 FROM b WHERE b.code = a.code)
![](https://img-blog.csdnimg.cn/img_convert/76e140dea4bbabdccedcad0acf44a624.png)
![](https://img-blog.csdnimg.cn/img_convert/957dc5cf6b1b3471b954e1293e392deb.png)
![](https://img-blog.csdnimg.cn/img_convert/fde0766021dd03b860983b051d1fd797.png)
执行结果:
![](https://img-blog.csdnimg.cn/img_convert/673dde8d1e149c6b578e36d76a0f5966.png)
--a, b具有相同的code, 将a.name值, 全部更新为 b.NAME值
UPDATE a SET a.NAME =
(SELECT b.NAME FROM b WHERE b.code = a.code)
WHERE EXISTS (SELECT 1 FROM b WHERE b.code = a.code)
执行结果: