SQL多行合并为一列

SELECT SUBSTRING((SELECT '、' + U.USERNAME FROM TBUSER U WHERE U.RECORD_ID=RECORD.RECORD_ID FOR XML PATH('')) , 2 , 10000) FROM TBRECORD RECORD