derkenstock
Programmer
Essentially I'm attempting to accomplish concatenating data in a field for records that share the same key in a particular table, as shown below.
I've seen the GROUP_CONCAT(), and LISTAGG() listed on other similar questions, and I am familiar with implementations that would solve the situation below but it seems like PervasiveSQL 13 does not have support for these functions. I am wondering if Pervasive supports anything that I could use to solve my issue.
Either of the following solutions would be acceptable for my use case, but the first one would be more preferable.
OR
I've seen the GROUP_CONCAT(), and LISTAGG() listed on other similar questions, and I am familiar with implementations that would solve the situation below but it seems like PervasiveSQL 13 does not have support for these functions. I am wondering if Pervasive supports anything that I could use to solve my issue.
Code:
id colour
1 red
1 blue
2 green
2 red
Either of the following solutions would be acceptable for my use case, but the first one would be more preferable.
Code:
id colour
1 red, blue
2 green, red
OR
Code:
id colour1 colour2
1 red blue
2 green red