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
Use Group_Concat:
select Company.Name, Group_Concat(Employee.id)from Company inner join Employeeon Company.id = Employee.Company group by Company.id