Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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.)
SQL: Combine Multiple rows with the same field [message #1783401] Mon, 12 March 2018 15:59
Tyler Gillette is currently offline Tyler GilletteFriend
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.
Previous Topic:Birt JNDI Connection on Weblogic
Next Topic:Page Break when displaying large text
Goto Forum:
  


Current Time: Sat Apr 21 10:09:31 GMT 2018

Powered by FUDForum. Page generated in 0.01949 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software