查询两张关联表信息,原sql:

SELECT * FROM  car_life_info c

left JOIN shop_label sl

ON  c.shop_id = sl.shop_id 

 

出现重复 店铺名称

 

 合并 后面列label

新sql:

SELECT c.*,group_concat(sl.label_id) label_ids ,group_concat(l.label_name ) label_names
FROM car_life_info c
LEFT JOIN shop_label sl
ON c.shop_id = sl.shop_id
LEFT JOIN label l
ON sl.label_id = l.label_id
group by shop_id

 

问题解决!

 

posted on 2018-04-24 17:24  VectorEar  阅读(486)  评论(0编辑  收藏  举报