mysql 随笔

(select GROUP_CONCAT(car_brand_name separator ',') carBrandName,supplier_id
from ycej_supplier_carbrand
GROUP BY supplier_id) c
on s.supplier_id = c.supplier_id