方法一:
UPDATE A SET ywdw = B.ywdw_id
FROM A,B
WHERE A.ywdw = B.ywdw方法二:
UPDATE A SET ywdw = (SELECT ywdw_id FROM B WHERE B.ywdw=A.ywdw)
UPDATE A SET ywdw = B.ywdw_id
FROM A,B
WHERE A.ywdw = B.ywdw方法二:
UPDATE A SET ywdw = (SELECT ywdw_id FROM B WHERE B.ywdw=A.ywdw)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货