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
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