Sql Query for multiple items returns in comma seperated model

Hi all

Select * from table_details returns


Code Salesman date status

1 s1 1/1/2014 Y
2 s2 2/1/2014 Y
2 s1 2/1/2014 Y
3 s2 3/1/2014 Y


i want query to return rows like

Code Salesman date status

1 s1 1/1/2014 Y
2 s2,s1 2/1/2014 Y
3 s2 3/1/2014 Y

How to do this

Thanks in Advance

Amritha