title: Cognos SQL multiple rows to one row
body: <p>The issue I'm having is that the note table allows for multiple entries and I would like it to be in one row for each stock code. I would like this done on the query side.   I have tired to several different ways that I know in sql to do it but I keep getting unrecognizable query framework response(example shown blow </p>
  
  <p>stock_code  &nbsp;&nbsp;&nbsp;&nbsp;note_sequence &nbsp;&nbsp;&nbsp;&nbsp;        stock_note <br/>
  ++++++++++&nbsp;&nbsp;+++++++++++++&nbsp;&nbsp;&nbsp;++++++++++ <br/>
  3051715&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sold in sets<br/>
  3051715&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  From vendor 9999 15; but <br/>
  3051715&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;will be sold separately <br/>
     <br/>
  stock_code &nbsp;&nbsp;&nbsp;&nbsp;        stock_note <br/>
  ++++++++++&nbsp;&nbsp;+++++++++++++<br/> 
  3051715&nbsp;&nbsp;&nbsp;&nbsp;Sold in sets,From vendor 999 15; but will be sold separately       </p>