(STUFF((select ',' + USER_NAME from TBL_BIZ_TRSBILLS_DETAIL where TRANSPORT_CODE = TB.TRANSPORT_CODE and USER_TYPE = '司机' for xml path('')),1,1,'' )) AS DRIVER_NAMES(STUFF((select ',' + USER_NAME from TBL_BIZ_TRS
阅读背景：
将检索出来的列按逗号拼接起来
来源：互联网
分享到：
