# Combine all rows of on column - group by problem

**URL:** <https://forum.kirupa.com/t/combine-all-rows-of-on-column-group-by-problem/326938>\
**Category:** programming\
**Created:** [January 24, 2012, 10:42am UTC](https://forum.kirupa.com/t/combine-all-rows-of-on-column-group-by-problem/326938 "2012-01-24T10:42:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jerome\_chevreau](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@jerome\_chevreau](https://forum.kirupa.com/u/jerome_chevreau)\
**Post date:** [January 24, 2012, 10:42am UTC](https://forum.kirupa.com/t/combine-all-rows-of-on-column-group-by-problem/326938/1 "2012-01-24T10:42:04Z")

</div>

Hi there,

I have one table which has 3 cols.

1. user id
2. details
3. value

EXAMPLE  
PK userid DETAILS VALUE  
1 1 basics name1  
2 1 privileges some details  
3 2 basics name2  
4 2 privileges some details  
5 3 basics name3  
6 3 privileges some details

but when i make a look up and use “group by” userid then i dont have all the details all together when using group by.

Is there a way of achieving that please

Thanks for all the help,

Regards  
Jerome