How to concatenate/join strings from a grouped column in SQLite?

Question

Having

Company
id      Name
1       Enron
2       Walmart

Employee
id      Company
2       1
3       1
4       2
5       2
6       2

I want to get

Enron 2,3
Walmart 4,5,6

so far I wrote:

select Company.Name, Employee.id
from Company inner join Employee
on Company.id = Employee.Company 
group by Company.id

but the current result is

Enron 2
Walmart 4

MPelletier · Accepted Answer · 2011-04-18 19:26:14Z

37

select Company.Name, Group_Concat(Employee.id)
from Company inner join Employee
on Company.id = Employee.Company 
group by Company.id

answered Apr 18, 2011 at 19:26

MPelletier

16.8k18 gold badges90 silver badges140 bronze badges

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

1 Answer 1