我寫了一個語句：select d_name as '區縣',鄉鎮,普查區,普查小區 from dress,(select d_name as '鄉鎮',普查區,普查小區,d_pid as pid from dress,(select num as '普查小區',d_name as '普查區',d_pid as pid from pcxq,dress where pcxq.code=dress.d_code) as pcqwhere dress.d_id=pcq.pid) as xzwhere dress.d_id=xz.pid 感覺可能復雜了，求高手指點。