mysql 分组查询

SELECT group_concat(u.prize) AS prize, group_concat(u.code) AS code   FROM `lc_unique` AS u  INNER JOIN  `lc_baoming`  AS b ON u.webcookie = b.webcookie  GROUP BY u.webcookie

 

posted @ 2017-04-27 10:09  Abner3721  阅读(109)  评论(0编辑  收藏  举报