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

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


Use Group_Concat:

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