group sub select

Last Post 17 Apr 2009 12:36 PM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
timcronin
New Member
New Member

--
17 Apr 2009 12: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



Acceptable Use Policy
---