SQLServer,将查询的数据转换为一行

		SELECT 
			t.id,
			string_agg(t.ability, '; ') AS aaaa
		
		
		
		FROM (
		
						select
							worker.id,
							CONCAT(ability.ability_name,':', classCode.name) AS ability

						FROM SmartFactory.dbo.tbl_b_worker AS worker
						LEFT JOIN SmartFactory.dbo.tbl_b_worker_ability_map_info AS abilityMap ON abilityMap.worker_id = worker.id 
						LEFT JOIN SmartFactory.dbo.tbl_b_ability AS ability ON ability.id = abilityMap.ability_id 
						LEFT JOIN SmartFactory.dbo.tbl_b_class_code AS classCode ON classCode.code = abilityMap.worker_ability_level AND kubun = 'AbilityLevelType'
						WHERE
						worker.deleted = 0
						AND abilityMap.deleted = 0
						AND ability.deleted = 0
		) AS t
		
		GROUP BY t.id

使用char(10)可以结果集换行

例:

技能1:A

技能2:B

技能3:C

.....