I have a parent record with 0-n child records. The child records contain a field that I want to combine all the values into a single comma delimited string. I want to run a SQL7 query that will choose the parent record once and create the comma delimeted string as a field in the result set instead of choosing the parent record repeatedly for each child record. Is there any way to do this with SQL only, i.e.:no stored procedure?

Thanks in advance for any help with this.

Don