测试数据:
city表:
create table city(id int,name text);
insert into city values(0,'北京'),(1,'西安'),(2,'天津'),(3,'上海'),(4,'哈尔滨'),(5,'西藏')
person表:
create table person(id int,lastname char(20));
insert into person values(0,'Tom'),(2,
city表:
create table city(id int,name text);
insert into city values(0,'北京'),(1,'西安'),(2,'天津'),(3,'上海'),(4,'哈尔滨'),(5,'西藏')
person表:
create table person(id int,lastname char(20));
insert into person values(0,'Tom'),(2,