Field value in multiple rows -to- a single row

[mikejaytlabustro]

Hello! I'm having trouble with a query right now

From this scenario:
-------------------------------------
ID SeqNo Value
-------------------------------------
1 1 A
1 2 C
1 3 E
2 1 B
2 2 D
2 3 F
-------------------------------------

To this one:
-------------------------------------
ID Value
-------------------------------------
1 ACE
2 BDF
-------------------------------------
Many Thanks!

 

[CJ_London]

sounds like you need to use the concatrelated function - see this link

http://allenbrowne.com/func-concat.html