(imported topic written by SystemAdmin)
I’m trying to get a report that will list the names of the bes custom sites and in the next columns list the writers and readers of those sites. The clause below does just that but… the format the results come back in is not exactly what I had in mind.
(name of it, names of writers of it, names of readers of it) of bes custom sites
The results look like this:
site1,writer1,reader1
site1,writer1,reader2
site1,writer1,reader3
site1,writer2,reader1
site1,writer2,reader2
site1,writer2,reader3
and on and on and on…
What I’d like is this:
site1, writer1, reader1
writer2, reader2
writer3, reader3
site2, writer1, reader1
etc…
or
site1
writers,readers
site2
writers,readers
Does that make sense? Is there anyway to write the clause to do this?
-Baraq