22,209
社区成员
发帖
与我相关
我的任务
分享
若Station表中stationName和表Town中的townName相同,则把Station表中linknum更新为和Town表中的ID相同。
update station
set linknum=town.id
from station,town
where station.stationname=town.townname
UPDATE Station
SET linknum = a.linknum
FROM #back a
where Station.stationID = a.stationID
--or
UPDATE b
SET linknum = a.linknum
FROM #back a join Station b
on a.stationID = b.stationID
update station set linknum=(select id from town where townname=a.stationname) from station a
--TRY
UPDATE Station
SET linknum = s.linknum FROM #back b join Station s ON S.stationID = b.stationID