group_concat函数

函数语法：

group_concat( [DISTINCT] 要连接的字段 [Order BY 排序字段 ASC/DESC] [Separator ‘分隔符’] )

SELECT
	m.supp_cust,
	GROUP_CONCAT(
		DISTINCT m.CLASS_NAME
		ORDER BY
			m.CLASS_NAME SEPARATOR "--"
	)
FROM
	sc_suppnetin_mate m
GROUP BY
	m.supp_cust
order by m.supp_cust