title: SQL Sybase - How to display on the same row
body: <p>Apologies as I'm really new to SQL, and I'm trying to create a code that would extract all values in the same row, in their same respective identifiers (fundno and fund name).</p>
  
  <p>What I want is all the values are in the same row, and not separated.</p>
  
  <p>select </p>
  
  <pre><code>b.fundno,
  a.fund_name,
  a.fund_type As Type,
  a.fund_status_code As Status,
  a.category_code as 'CatCode',
  convert(char(10),b.prosp_date,101)as 'Prospectus_date',
      (case when b.prosp_code = 'GRMFEE' then b.prosp_value end) as GrMgmt,
      (case when b.prosp_code = 'GR12B1' then b.prosp_value end) as Gr12b1,
      (case when b.prosp_code = 'GROTHR' then b.prosp_value end) as Groth,
      (case when b.prosp_code = 'GREXP' then b.prosp_value end) as Grtotal,
      (case when b.prosp_code = 'NETMFEE' then b.prosp_value end) as Netmgmt,
      (case when b.prosp_code = 'NET12B1' then b.prosp_value end) as Net12b1,
      (case when b.prosp_code = 'NETOTHR' then b.prosp_value end) as Netoth,
      (case when b.prosp_code = 'EXPLIMIT' then b.prosp_value end) as Nettotal,
      (case when b.prosp_code = 'NETWVR' then b.prosp_value end) as Waiver
  
  from 
  fund a,
  prospectus_breakdown b
  
  where a.category_code in(1,13,16,18,19,20,27,31)
  
  and b.fundno = a.fundno
  
  
  and b.prosp_date=(select max(prosp_date)
                              from prospectus_breakdown b
              where b.fundno=a.fundno)
  
  order by a.fund_name
  </code></pre>
  
  <p>What appears is this:</p>
  
  <p><a href="https://imgur.com/a/dqPRQ6X" rel="nofollow noreferrer">https://imgur.com/a/dqPRQ6X</a></p>
  
  <p>Can anyone please help me fix the code? Any kind of help would be really appreciated. Thank you!!</p>