跨表更新
发表时间: 2006-11-23 11:58:54 | 评论: 0 | 浏览: 104 | 来自: LUKIYA_NEVERLAND
今天做地域分类数据库，遇到了转换问题，需要跨表更新。
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