SQL求和值从多到多

Question

这是我的sql数据：

id  name  prod_id  price
------------------------
9    A     23      4100
94   B     40      1500
94   B     36      1500

我希望最终拥有：

id  name  prod_id  price
------------------------
9    A     23      4100
94   B     40,36   1500

这是我尝试使用GROUP BY 的代码

SELECT 
company.id,
company.name,
order_product.product_id,
SUM(orders.price)
FROM
orders
INNER JOIN users ON orders.user_id = users.id
INNER JOIN order_product ON orders.id = order_product.order_id
INNER JOIN customer ON orders.customer_id = customer.id
INNER JOIN company ON customer.company_id = company.id
GROUP BY
company.id,

Answer 1

group_concat应该完成

SELECT 
company.id,
company.name,
group_concat(order_product.product_id9,
orders.price
FROM
orders
INNER JOIN users ON orders.user_id = users.id
INNER JOIN order_product ON orders.id = order_product.order_id
INNER JOIN customer ON orders.customer_id = customer.id
INNER JOIN company ON customer.company_id = company.id
group by 
company.id,
company.name,
orders.price