Can anyone tell me how to perform the equivalent of a Group Concat function in Progress SQL? I want to get a concatenation of multiple records into a single record.
For example, this SQL produces a set of data
SELECT data1 FROM table1 WHERE data2=True
+-------+
| data1 |
+-------+
| somet |
|...
I can't believe this hasn't been asked before but I've searched and haven't found anything on this topic.
I'm just starting with OpenEdge 10.0B03 and I'd like to insert multiple records with a single insert statement like I do in MySQL
In MySQL I can do the following,
Insert Into Tablename...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.