Eclipse Community Forums: BIRT » SQL: Combine Multiple rows with the same field

Home » Archived » BIRT » SQL: Combine Multiple rows with the same field(I have a table with an order number and a description, the description spans across multiple rows.)

Show: Today's Messages :: Show Polls :: Message Navigator

SQL: Combine Multiple rows with the same field [message #1783401]

Mon, 12 March 2018 15:59

Tyler Gillette

Messages: 1
Registered: March 2018
Location: Clovis, Ca

Junior Member

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.

Order# Description
728123 WHITE
728123 35.00X45.00
728123 EXTRA
728123 SANDBLASTED OUTTER
728123 CHARCOAL FLAT
728123 SP
728123 BT
728123 NO GLAZE
728123 EXTRA STICKS
728125 WHITE
728125 56.00X24.00

Another bit of information that may be helpful, is that we are using a DB2 as400 database.

Any help would be greatly appreciated.

Report message to a moderator