I have an interesting problem (I think).

I have table1
mykey myvalue
a x
a y
a z
b c
b d
b e
b f
b g

I want to end up with table2
mykey myvalues
a xyz
b cdefg

I can do this concatenation using a scan, but I want to do it only using SQL. The number of values for a key is random.

TIA
Robert