Displaying data from multi row to single row 1

[egodette]

I have a table with 3 fields. These fields contain duplicate entries for two of the fields. This SQL statement produces these results.
SELECT * FROM MULTCLAS WHERE TICKER = 'TLP'
TLP XZ PRT
TLP XZ SHL

What I want is an sql query that procudes:
TPL XZ PRT SHL

Any help would be appreciated..

 

[imex]

Try something like that:

SELECT TICKER, COLUMN2, STUFF( (SELECT ' ' + COLUMN3
                                FROM MULTCLAS
                                WHERE (TICKER = M.TICKER) AND (COLUMN2 = M.COLUMN2)
                                FOR XML PATH(''), TYPE).value('.', 'varchar(max)')
                                ,1, 1, '')
                                 
FROM MULTCLAS AS M
GROUP BY TICKER, COLUMN2

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial-apartamento[/url]