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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top