SQL 将一列数据以逗号拼接在一行中展示

SELECT DISTINCT
	pf.FILE_TYPE_ID AS id,
	F.FILE_TYPE AS fileType,
	fileName = (
	stuff(
	( SELECT ',' + FILE_NAME FROM PI_ATTACH_FILE WHERE FILE_TYPE = F.FILE_TYPE FOR XML PATH ( '' ) ),
	1,
	1,
	'' 
	) 
	),
	type.SEQUENCE AS typeSequence,
	DISK_DOC_ID = (
	stuff(
	( SELECT ',' + DISK_DOC_ID FROM PI_ATTACH_FILE WHERE FILE_TYPE = F.FILE_TYPE FOR XML PATH ( '' ) ),
	1,
	1,
	'' 
	) 
	) 
FROM
	PI_ATTACH_FILE AS F,
	PI_ACH_ARCHIVES_FILE PF,
	PI_ACH_ARCHIVES_FILETYPE type 
WHERE
	F.ID = PF.FILE_ID 
	AND type.id = pf.FILE_TYPE_ID 
	AND PF.ORDER_CD = '1111' 
GROUP BY
	F.FILE_TYPE,
	pf.FILE_TYPE_ID,
	type.SEQUENCE 
ORDER BY
	pf.FILE_TYPE_ID ASC;
	

效果图

其中查询字段 使用的表名请自行替换