12SELECT Customer_ID,Customer_Name,<a href="https://www.baidu.com/s?
wd=STUFF&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y3ujRkn1R1uW9hryN-
njF90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnHm1rH04rH6snjnkn1mYnjR3n0" target="_blank"
class="baidu-highlight">STUFF</a>((SELECT ','+Linkman_Name FROM Linkman WHERE Customer_ID=Customer.Customer_ID FOR XML <a href=
"https://www.baidu.com/s?wd=PATH&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y3ujRkn1R1uW9hryN-
njF90ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnHm1rH04rH6snjnkn1mYnjR3n0" target="_blank"
class="baidu-highlight">PATH</a>('')),1,1,'') Linkman_Name FROM Customer
扩展资料；
把表名tt换下就可以了购买产品id是字符串类型的话用这个select a.客户id,stuff((select ','+购买产品id from tt b wherea.客户id=b.客户id for XML path('') ),1,1,'') gg from tt a group by a.客户id
如果购买产品id是整型的话，用这个select a.客户id,stuff((select ','+cast(购买产品id as nvarchar(max)) from tt b wherea.客户id=b.客户id for XML path('') ),1,1,'') gg from tt a group by a.客户id
参考资料；百度百科-sql