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