orcal从同一段分别查出市和省，并分列显示

select t9.region_name 区
,(select region_name from crm_region r1 where r1.region_id=t9.parent_id) 市,
(select region_name from crm_region r1 where r1.region_id=(select parent_id from crm_region r1 where r1.region_id=t9.parent_id)) 省
 from crm_order t1,
 crm_region t9
 where  t1.region_id=t9.region_id

转载于:https://www.cnblogs.com/pcxlj/p/4978241.html