I have a similar problem...it may even be the same...I have something
and I want:
1 "A, B, C"
2 "D, E"
and so on.
Any help would be greatly appreciated.
> Need more information. Your results don't seem like a crosstab.
Is "1, a7,
> b1, a6" four separate columns or one column with the values
> into a string and delimitted by a comma and space? If separate
> what are the column names and how does value determine the column it
> in? Why are your results missing ID 3 and 5?
> Hi All
> I have a table that lists and id and a product number. Each id could
> 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
Sent via Deja.com http://www.deja.com/
Before you buy.