不知我理解的对不对:
SELECT Customer_ID,Customer_Name,STUFF((SELECT ','+Linkman_Name FROM Linkman WHERE Customer_ID=Customer.Customer_ID FOR XML PATH('')),1,1,'') Linkman_Name FROM Customer