Help with query ...

Z

Zwi2000

I have this query:

Select b.caseid, a.userid from atts as a
inner join cases b on a.caseid = b.id
group by b.caseid, a.userid

Results:

Caseid Userid
DEMO0021H 3
DEMO0021H 6
DEMO0021H 7
DEMO0021H 8
H1b-34234 3
H1b-34234 6
H1b-34234 8
L-34234 3
StandardExp2121 3

INSTEAD I NEED TO GET:

Caseid Userid
DEMO0021H 3,6,7,8
H1b-34234 3,6,8
L-34234 3
StandardExp2121 3

How do I modify this query ?

Help is appreciated !

Z
 
Top