(Select STUFF(cast((Select '、'+oac.CITY_NAME FROM ORDER_AREA_CITY oac
where oac.ORDER_AREA_DETAIL_ID = oad.ORDER_AREA_DETAIL_ID FOR XML PATH('')) as varchar(1000)),1,1,'')) as PROV_NAMES,
关键就是这一句,仔细看下就懂了,感觉比较实用:
(Select '、'+oac.CITY_NAME FROM ORDER_AREA_CITY oac
where oac.ORDER_AREA_DETAIL_ID = oad.ORDER_AREA_DETAIL_ID FOR XML PATH('')) as varchar(1000)),1,1,'')) as PROV_NAMES