SqlServer 将查询出的多行数据拼成一个字符串返回

SELECT main_id,main_name,
main_hobby=STUFF((SELECT ','+sub_hobby FROM 
table_sub WHERE main_id=t.main_id FOR XML PATH('')),1,1,'')
FROM table_main t
GROUP BY main_id,main_nameSELECT main_id,main_name,
main_hobby=STUF