SQL Server使用多对多相关表连接行

我建议使用

For XML

STUFF

SELECt O.OrderId ,STUFF(        ( SELECT ',' + E.Name AS [text()]     FROM OrderExtras OE         Inner Join Extras E   ON E.ExtrasId = OE.OrderExtras_ExtrasID     WHERe O.OrderId = OE.OrderExtras_OrderID ORDER BY E.Name FOR XML PATH('')        ), 1, 1, '') AS ColListFROM Orders O

这是SQL Fiddle。

祝你好运。