您将为此使用
FOR XML PATH：
select p.name, Stuff((SELECT ', ' + s.skillName FROM skilllink l left join skill son l.skillid = s.id where p.id = l.personid FOR XML PATH('')),1,1,'') Skillsfrom person p参见带有演示的SQL Fiddle
结果：
| NAME | SKILLS |----------------------------| Bill | Telepathy, Karate || Bob | (null) || Jim | Carpentry |
