[thelist] [SQL] tough concatenation
Warden, Matt
mwarden at odyssey-design.com
Fri Apr 13 17:00:04 CDT 2001
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
More information about the thelist
mailing list