Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    5

    Unanswered: concatenate values of same table in a row

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You should be able to do it with recursive SQL.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •