mysql - Combining rows where dublicates are found

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65939272/combining-rows-where-dublicates-are-found

Answer 1

you could try using group_concat

    select Computer.ID, group_concat(harddisk.id)
    from Computer 
    inner join harddisk on Computer.id = harddisk.computerID
    group by Computer.ID