mysql GROUP_CONCAT(query)

Question

I'm trying to run a query that looks like:

SELECT
  GROUP_CONCAT(vehicles.id)  
FROM                                                                
 vehicles                         
WHERE                                                               
 cars.id = vehicles.id

brings the right data:

1,2,3

However, now I want the brand name using GROUP_CONCAT

SELECT
  GROUP_CONCAT(SELECT brand_name FROM brands WHERE vehicles.id = brand.id) 
FROM                                                                
 vehicles                         
WHERE                                                               
 vehicles.id = 100

so I can get 'Brand1', 'Brand2', 'Brand3'

What is WHERE cars.id = vehicles.id? there is no cars in your query. — Martin Smith
– Martin Smith, Commented Feb 18, 2011 at 18:59

nickmoriarty · Accepted Answer · 2011-02-18 19:02:03Z

9

try

SELECT
  GROUP_CONCAT(brands.brand_name) 
FROM                                                                
 vehicles
 inner join brands on vehicles.id=brands.id 
 inner join cars on cars.id=vehicles.id                       
WHERE                                                               
 cars.id = vehicles.id

answered Feb 18, 2011 at 19:02

nickmoriarty

1,26319 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql GROUP_CONCAT(query)

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related