Query - Repeating types agrupping in fields separated with comma instead of different rows

danonino

I want to make the following query

select group_name,i_all_users_names
from dm_group

But I don´t know if is possible to get every group in only one row with its different users separated with commas, is it possible??

Miller-zzMST

Hi,

Just add some single attribute to your query, like this:

select r_object_id, group_name, i_all_users_names from dm_group

~ Konstantin