帮你就帮到底吧，虽然不会，但google是万能的

UPDATE tab1 a
SET a.name =
(SELECT b.name
FROM tab2 b
WHERE a.code= b.code)
WHERE EXISTS (
SELECT b.name
FROM tab2 b
WHERE a.code= b.code)