跨表更新
今天做地域分类数据库,遇到了转换问题,需要跨表更新。
Sql语句如下
UPDATE
zone_Cities
SET Province =
( SELECT Id FROM zone_Provinces WHERE lbk_Cities.Province = zone_Provinces.Province)
FROM zone_Cities, zone_Provinces
SET Province =
( SELECT Id FROM zone_Provinces WHERE lbk_Cities.Province = zone_Provinces.Province)
FROM zone_Cities, zone_Provinces