TblArea 字段 AreaId、 AreaName、AreaPid
select
t1.AreaId 城市编号,
t2.AreaName 城市名称,
t1.AreaName 省份名称
from TblArea as t1
inner join TblArea as t2 on t1.AreaId=t2.AreaPid
TblArea 字段 AreaId、 AreaName、AreaPid
select
t1.AreaId 城市编号,
t2.AreaName 城市名称,
t1.AreaName 省份名称
from TblArea as t1
inner join TblArea as t2 on t1.AreaId=t2.AreaPid
原文：http://www.cnblogs.com/hao-1234-1234/p/8025481.html