update A set tel = (select tel from B where B.fid=A.fid) where exists (select 1 from B where B.fid = A.fid)
05-17
3621
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-10
792
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-03
3692
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
update A set tel = (select tel from B where B.fid=A.fid) where exists (select 1 from B where B.fid = A.fid)