[thelist] [SQL] tough concatenation

[Warden, Matt]

evoltineers,

I have a 1-M relationship between widgets and widget parts. For a given
widgetID, I'd like to return a string of all the widget parts. So, if this
is true:

SQL> select widgetparts from widgets where widgetid=4;

.-------------.
| widgetparts |
|-------------|
|   handle    |
|    body     |
|   gipode    |
|   carpet    |
.-------------.


I want to get it to return:

handle,body,gipode,carpet

through SQL. I do *NOT* want to iterate through the results and make my own
string.


thoughts?


--
mattwarden
mattwarden.com