|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Combine results into one fieldIf I do a basic query
select * from grouping where code='12345' I get the results (fields are code,result) 12345 aaaaa 12345 assas 12345 f5fgh I NEED to get it as aaaaa,assas,f5fgh. Since code is all the same, I just want one result. Possible? *** Sent via Developersdex http://www.developersdex.com ***
http://www.aspfaq.com/2529
Show quote "Joey Martin" <j***@kytechs.com> wrote in message
news:eUn4NjrTGHA.4308@TK2MSFTNGP10.phx.gbl... > If I do a basic query > select * from grouping where code='12345' > I get the results > (fields are code,result) > 12345 aaaaa > 12345 assas > 12345 f5fgh > > > I NEED to get it as aaaaa,assas,f5fgh. Since code is all the same, I > just want one result. Possible? > > *** Sent via Developersdex http://www.developersdex.com *** |
|||||||||||||||||||||||