SELECT po.id,(SELECT GROUP_CONCAT(mr.member_type) as memberTypeList FROM prod_offer_member_rel mr WHERE mr.prod_offer_id = po.id) as memberTypeListfrom prod_offer po
mysql有多条记录的单个字段想存为一个字段显示的方法
原文:http://www.cnblogs.com/chenwh/p/6396993.html