需要树形表SQL的请进

[xunqinbo]

本帖仅供参考

`
CREATE TABLE "region" (
"code" integer NOT NULL,
"name" text NOT NULL,
"parentCode" integer NOT NULL,
"level" integer NOT NULL,
CONSTRAINT "pk_code" PRIMARY KEY ("code")
);

INSERT INTO region
SELECT code,name,0,1
FROM province;

INSERT INTO region
SELECT code,name,provinceCode,2
FROM city;

INSERT INTO region
SELECT code,name,cityCode,3
FROM area;

INSERT INTO region
SELECT code,name, areaCode,4
FROM street;

INSERT INTO region
SELECT code,name,streetCode,5
FROM village;

`