有两张表,结构、数据如下图:
demo_county表:
demo_countyCode表:
demo_county表的county匹配demo_countyCode表的countyVal,并把demo_countyCode表相应的code插入到demo_county表的code列。T-SQL如下:
update t1 set t1.code=t2.code
from demo_county t1,demo_countyCode t2
where t1.county=t2.countyVal
可得结果: