部门查询:
select b.区域ID,c.区域,a.城市ID,b.城市,a.部门ID,部门,a.父部门ID,dlookup("部门","部门表","部门ID=" & 父部门ID) as 父部门
from 部门表 as a inner join 城市表 as b on a.城市ID=b.城市ID inner join 区域表 as c on b.区域ID=c.区域ID
城市查询:
select a.区域ID,b.区域,a.城市ID,a.城市
from 城市表 as a inner join 区域表 as b on a.区域ID=b.区域ID