[MSSQL] SELECT XML PATH 행데이터로 변경

SELECT DISTINCT ID, STUFF((SELECT ','+XX.NAME FROM
(SELECT B.ID, S.NAME
FROM TB_1 B
INNER JOIN TB_2 BS ON (B.IDX = BS.IDX)
INNER JOIN TB_3 S ON (BS.IDX1 = S.IDX1)
WHERE B.IDX2 = '') XX
WHERE XX.ID = YY.ID
FOR XML PATH('')),1,1,'') AS NAME

FROM (SELECT B.ID, S.NAME
FROM TB_1 B
INNER JOIN TB_2 BS ON (B.IDX = BS.IDX)
INNER JOIN TB_3 S ON (BS.IDX1 = S.IDX1)
WHERE B.IDX2 = '') YY



중요한 부분
SELECT DISTINCT ID,
STUFF((SELECT ','+ name FROM
FROM TB_TABLE B
WHERE B.ID = A.ID
FOR XML PATH('')),1,1,'') AS NAME


FROM TB_TABLE A