同一张表省市区三级联查

思路:

province.id = city.parent_id

city.id = distrct.parent_id;

SQL语句:

SELECT

a.NAME province,

b.NAME city,

c.NAME distrct

FROM

TABLE a,

TABLE b,

TABLE c

WHERE

a.id = b.parent_id

AND b.id = c.parent_id;