title: Get multiple column values from joined table in a comma separated list
body: <p>I have 3 tables which contains rows like below:</p>
  
  <p><strong>RESEARCH_REPORTS</strong> table:</p>
  
  <pre><code>REPORT_ID   TOPIC
  141         My Report Topic Title
  142         Another Report Topic Title
  143         Yet Another Report Topic Title
  ...
  </code></pre>
  
  <p><strong>PROGRAM_AREAS_REPORTS_REL</strong> table:</p>
  
  <pre><code>REPORT_ID    PROGRAM_AREA_ID
  141          6
  141          11
  141          12
  ...
  </code></pre>
  
  <p><strong>PROGRAM_AREAS</strong> table:</p>
  
  <pre><code>PROGRAM_AREA_ID    TITLE
  6                  Program Area One
  11                 Program Area Two
  12                 Program Area Three
  ...
  </code></pre>
  
  <p>This query is currently returning me the results from down below:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT rr.report_id, rr.topic, pa.title as program_areas 
  FROM RESEARCH_REPORTS rr 
  INNER JOIN PROGRAM_AREAS_REPORTS_REL parr ON rr.report_id = parr.report_id 
  INNER JOIN PROGRAM_AREAS pa ON parr.program_area_id = pa.program_area_id 
  WHERE rr.report_id = 141
  </code></pre>
  
  <p><strong>Query Results</strong>:</p>
  
  <pre><code>report_id    topic                    program_areas
  141          My Report Topic Title    Program Area One
  141          My Report Topic Title    Program Area Two
  141          My Report Topic Title    Program Area Three
  </code></pre>
  
  <p>I need a select query which results in the following format:</p>
  
  <p><strong>Preferred Query Results</strong>:</p>
  
  <pre><code>report_id    topic                    program_areas
  141          My Report Topic Title    Program Area One, Program Area Two, Program Area Three    
  </code></pre>
  
  <p>How can I accomplish this on my current query?</p>