query not giving proper result

[binoyshil]

i want to concatenate values of three column in one row

for example my data is:
Binoy> select * from fpfm_nominies where emp_no='1283L';

EMP_NO NOMINEE
------- -------------------------
1283L Lal Mathi
1283L POONAM KUMARI
1283L SUMAN KUMARI .
it generates three different records with same emp_no but different
nominee. now i want to show names of all nominee in one row through select query only.something like this:

emp_no name
-------- -------------------------------------------
1283L Lal Mathi,POONAM KUMARI,SUMAN KUMARI


can anyone help me out.

[LKBrwn_DBA]

This question has been asked thousands of times, do some research!

Hint: 'pivot table', 'crosstab', 'rows to columns',...