이거 원하시는 건지??? STUFF 찾아보세요...

CREATE TABLE dbo.TableA

(

       seq INT,

       title VARCHAR(20)

)

GO

CREATE TABLE dbo.TableB

(

       seq INT,

       ASeq INT,

       name VARCHAR(20)

)

GO

INSERT INTO dbo.TableA (seq, title) VALUES (1, '1번 제목입니다.');

INSERT INTO dbo.TableA (seq, title) VALUES (2, '2번 제목입니다.');

GO

INSERT INTO dbo.TableB (seq, Aseq, name) VALUES (1, 1, '홍길동');

INSERT INTO dbo.TableB (seq, Aseq, name) VALUES (2, 2, '유관순');

INSERT INTO dbo.TableB (seq, Aseq, name) VALUES (3, 2, '김유신');

GO

SELECT A.seq, A.title, B.Bseq, B.name

FROM

       dbo.TableA A LEFT JOIN

       (

             SELECT

                    DISTINCT Aseq AS seq,

                           STUFF((

                                 SELECT ',' + CONVERT(VARCHAR(20),seq)

                                 FROM    TableB b

                                 WHERE   b.Aseq = a.Aseq

                                 FOR XML PATH('')

                           ),1,1,'') AS Bseq,

                           STUFF((

                                 SELECT ',' + name

                                 FROM    TableB b

                                 WHERE   b.Aseq = a.Aseq

                                 FOR XML PATH('')

                    ),1,1,'') AS name

             FROM TableB a

       ) B ON A.seq = B.seq

결과

http://msdn.microsoft.com/en-us/library/aa259350(v=sql.80).aspx

오류가 나네요;;

'XML' 근처의 구문이 잘못되었습니다.
'FOR' 키워드 근처의 구문이 잘못되었습니다.

어찌하였든,  STUFF 라는게 있다는건 알게되었네요.. 감사합니다.