This doesn't pivot the results. I wanted the the data from several matching rows in the Many table to come back as a single value of data separated by commas in the results table.

Suppose I had the following Many table...

ID DATA

-- ------

56 run

56 jump

56 scale

After the pivot the results data would look like this...

ID Result

-- ----------------

56 run, jump, scale