两个表的多个字段进行匹配

两个表的,比如 一个表存在省id 市id 县id
另一个表是具体的行政区划id对应的详细描述
将这个两个表做关联

select uo.organize_id,uo.organize_code,(select GROUP_CONCAT(a.area_title separator ‘/’) from uc_area a where a.area_id in(uo.province_id,uo.city_id,uo.county_id) ORDER BY a.area_type) as area_title
from uc_organize uo where organize_id in(2,34,129,130,131,132,133,134,135,219);