省市(区)县三级查询sql脚本

1. 省市区sql文件地址   

   链接： http://pan.baidu.com/s/1slqIxeH     密码：k1oo

2.  

   例子

    

   SELECT
   	t3.name1,
   	t3.name2,
   	t4.area_name
   FROM
   	(
   		SELECT
   			t1.id id1,
   			t1.area_name name1,
   			t1.area_parent_id parent1,
   			t2.id id2,
   			t2.area_name name2,
   			t2.area_parent_id parent2
   		FROM
   			dt_area AS t1
   		LEFT JOIN dt_area t2 ON t1.id = t2.area_parent_id
   		WHERE
   			t1.area_parent_id = 0
   	) t3
   LEFT JOIN dt_area t4 ON t3.id2 = t4.area_parent_id
   WHERE
   	t4.id = '130402';