求教sql语句

如下：
有 A 表

name sex age

tom man
marry woman

B表

name age

tom 12
marry 13


如何用update语句将B表中的age更新到A表中的age中？

---

引用

SQL code

updata A
set age = (select age from B where name = A.name)
where exists(select 1 from B where name = A.name)

SQL code:

update A
set age = (select age from B where name = A.name)
where exists(select 1 from B where name = A.name)

---

update a set age = (select age from b where name = a.name);

---

学习了

---

答案都给全了~我还写了个！

---

update a set a.age=b.age from b where a.name=b.name

---

update A
set age = B.age
from A 
join B 
on A.name = B.name

---

SQL code:
UPDATE A SET age=(select age from B where B.NAME=A.NAME);