title: SQL Query to concatenate column values from multiple rows in Oracle
body: <p>Would it be possible to construct SQL to concatenate column values from
  multiple rows? </p>
  
  <p>The following is an example: </p>
  
  <p>Table A</p>
  
  <pre>
  PID
  A
  B
  C
  </pre>
  
  <p>Table B</p>
  
  <pre>
  PID   SEQ    Desc
  
  A     1      Have
  A     2      a nice
  A     3      day.
  B     1      Nice Work.
  C     1      Yes
  C     2      we can 
  C     3      do 
  C     4      this work!
  </pre>
  
  <p>Output of the SQL should be -</p>
  
  <pre>
  PID   Desc
  A     Have a nice day.
  B     Nice Work.
  C     Yes we can do this work!
  </pre>
  
  <p>So basically the Desc column for out put table is a concatenation of the SEQ values from Table B?</p>
  
  <p>Any help with the SQL?</p>