How would I merge multiple cell values into rows of another table? If this is the example of rows from a table with Columns 1/2/3:
Red / Sky / 1
I want a new table with Columns 1/2/3:
Red / Sky / 1-2-3
Basically merging or concatenating the contents of column 3 for rows in which values in columns 1 and 2 match.
asked 20 Jun '12, 15:43
Look at the LIST aggregate function.
answered 20 Jun '12, 15:49