Hi all,

I have a table named company. as i forget to set primary key in the table
i find the table have records like this:
co_id co_ref1 co_ref2 co_ref3
c1 peter john
c1 john mary

Now i want to set the co_id as primary key but the key fields have records
with same key value. I want to write a sql to combine the above 2 records as:

c1 peter john mary

I have tried some sql statement but cannot do it. Can someone please tell
me how? thx.

Linda