group sub select

Last Post 17 Apr 2009 01:36 PM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
17 Apr 2009 01:36 PM
I have a table with 3 fields, member,seq, and results that looks like this

member seq results
100 1 add it
100 1 test
100 2 fortwo
100 2 moretw
100 3 NULL
200 1 2test1
200 2 2test2
200 2 2testit3

What I want is a to concatenate results grouping by member and seq

so I should get

member seq results
100 1 addit test
100 2 fortwo moretw

You are not authorized to post a reply.

Acceptable Use Policy