FOR XML PATH 多筆資料合併為一筆 SELECT [SalesOrderID],(SELECT [ ProductID] + ',' FROM [sales].[SalesOrderDetail] as s2WHERE s1.SalesOrderID= s2.
blog.xuite.net