Hi,

Suppose I have a table product with these values

p_id phase
1 analysis
1 requirement
2 analysis
2 completed
2 implemented

I need to create a table say product_edit which will look like

p_id phase
1 analysis,requirement
2 analysis,completed,implemented

How to do this? ie concatenate into a single row

You should be able to do it with recursive SQL.

Andy