Very Computer

I have a table that lists and id and a product number. Each id could be in
the table with several different product nos e.g

ID    Product
1      A7
1      B1
1      A6
2      A7
2      B2
3      A1
5      B2

Is there some way of writing my select line so that the results appear as :

1, a7, b1, a6
2, a7 , b2

Any help would be gratefully recieved

Regards Simon

Steve

Sent via Deja.com http://www.deja.com/
Before you buy.

Don.

Hi All

I have a table that lists and id and a product number. Each id could be in
the table with several different product nos e.g

ID    Product
1      A7
1      B1
1      A6
2      A7
2      B2
3      A1
5      B2

Is there some way of writing my select line so that the results appear as :

1, a7, b1, a6
2, a7 , b2

col1   col2
1      A
1      B
1      C
2      D
2      E

and I want:

col1    col2
1       "A, B, C"
2       "D, E"

and so on.

Any help would be greatly appreciated.

Thanks!
Mike

create table #b (col1 int,col2 varchar(5))
insert #b values(1,'A')
insert #b values(1,'B')
insert #b values(1,'C')
insert #b values(2,'D')
insert #b values(2,'E')

col1   col2
------ -----
1      A,B,C
2      D,E

Steve
Check out RAC (replacement for Access crosstab query) at:
www.angelfire.com/ny4/rac/
If you would like to try out the beta for new version 1.50
exclusively for sql server 2000 contact me.

Sent via Deja.com http://www.deja.com/
Before you buy.

Look for...
    "Re: String concatenation in a vew"

    posted 12/5/2000 8:34PM.

Don.

Hello
I have a similar problem...it may even be the same...I have something
like

col1   col2
1      A
1      B
1      C
2      D
2      E

and I want:

col1    col2
1       "A, B, C"
2       "D, E"