[ Mysql ] 한컬럼을 리스트로 뽑기(with GROUP BY , GROUP_CONCAT)

SELECT mo.order_id AS order_PK, dt.order_id AS order_FK, GROUP_CONCAT(mp.prod_name) as prod_list
FROM mkds_orders mo, mkds_order_details dt, mkds_products mp
WHERE dt.prod_id = mp.prod_id and mo.order_id = dt.order_id GROUP BY mo.order_id

 

 

 

 

 결과