|SQL: Combine Multiple rows with the same field [message #1783401]
||Mon, 12 March 2018 15:59
| Tyler Gillette
Registered: March 2018
Location: Clovis, Ca
I have a table that has an order# field (KEY) and a description field.|
The problem is that i need to combine the description fields, so that there is only one record for all of the description entries and one order#.
Does any one know how this can be done in SQL and works in BIRT.
I have tried group_concat, and a few other things but it looks like none of them are valid in whatever dialect of SQL we are using.
728123 SANDBLASTED OUTTER
728123 CHARCOAL FLAT
728123 NO GLAZE
728123 EXTRA STICKS
Another bit of information that may be helpful, is that we are using a DB2 as400 database.
Any help would be greatly appreciated.
Powered by FUDForum
. Page generated in 0.01949 seconds