abap database table data framing in program

Hi,

I have one requirement i have empid, empname, company.

eg : empid empname company.

123 ravi abc

123 ravi xyz

123 ravi efg

--------------------------------------------

123 ravi abc,xyz,efg---------------------------------------------------------------------------i want to capture like with comma in b/w compnay names in one row.

--> for that collect statement is not possible because empid is not primary key,,primary key another field , if have any code for this please provide me.