Sql连接映射表并用逗号分隔结果

Question

我有三个表。我已经使用查询连接了它，但我想在一行中用逗号分隔结果，而不是在另一行显示结果。

第一张表

 ProgrammeId | Name
====================
1 |Software Engineering                                         
2 | Game Design

第二张表

 CoordinatorId| CoordinatorName
====================
1 |Bob                                         
2 | Ted

3d表格

 ProgrammeId| CoordinatorId
====================
1 | 1                                         
1 | 2
2 | 1

这是一个疑问。

 SELECT a.ProgrammeId, a.Name, c.NameCoordinator
FROM Programme a
--Joining maptable for Programme and Coordinator
INNER JOIN ProgrammeCoordinators b
ON a.ProgrammeId = b.ProgrammeId
INNER JOIN Coordinator c
ON b.CoordinatorId = c.CoordinatorId

输出将是这样的：

 ProgrammeId| Name | CoordinatorName
==================================
1 | Software Engineer | Bob                                        
1 | Software Engineer  | Ted
2 | Game Design | Ted

我如何分开显示这个：

1 | Software Engineer | Bob, Ted

Answer 1

如果您的姓名长度为100:

SELECT a.ProgrammeId, a.Name(Name,' ',100), c.NameCoordinator
FROM Programme a
--Joining maptable for Programme and Coordinator
INNER JOIN ProgrammeCoordinators b
ON a.ProgrammeId = b.ProgrammeId
INNER JOIN Coordinator c
ON b.CoordinatorId = c.CoordinatorId