MYSQL group_concat 여러데이터 한 row로 합치기 SELECT B.vocNo ,group_concat(B.VOCB separator '_') as name FROM ( SELECT 1 AS vocNo , A.* FROM TBL_LIB_VOCB A WHERE A.VOCB IN ('DATA' , 'STOCK') ) B WHERE B.vocNo = 1 GROUP BY B.vocNo ; Programming/DB 2019.08.09