Hi,
I am Microsoft SQL Server 2005. I am fetching only distinct rows from the database and the code is
Code:
select distinct p.project_name,build_name,emp_name
from project_master p
	inner join build_master b on b.proj_id = p.project_id
	inner join project_schedule s on s.build_id = b.build_id 
	inner join emp_master e on e.emp_id = s.emp_id
it returns rows like this
project_name | build_name | emp_name
sony | b1 | aaa
sony | b1 | bbb
samsung | b3 | ccc
samsung | b3 | bbb

Is it possible to concatenate emp_name when other two are distinct like this
project_name | build_name | emp_name
sony | b1 | aaa,bbb
samsung | b3 | ccc,bbb