title: SQL One to many relationships, duplicate/results being returned as unique rows
body: <p>I have a database and some of the tables have one to many relationships. How do I eliminate the results being returned as its own unique row?</p>
  
  <p>For instance I have a initiative table and a initiative can have many funding requirements. When I perform an inner join I'm getting the results but it looks like the rows are duplicating to output a unique value from the funding table. </p>
  
  <p><a href="https://i.stack.imgur.com/X9gJ3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/X9gJ3.png" alt="Results"></a></p>
  
  <p>From the results, it should be like this</p>
  
  <p>Row 3,4,5 should be in one row listing the results with the the funding required</p>
  
  <pre><code>Description | Acad_priority_1 | Acad_priority_2 | beginning_fiscal_year |
  Develop...  |  false          | true            | 2018/2019             |
                                                  | 2018/2019             |
                                                  | 2019/2020
  </code></pre>
  
  <p>Can you please steer me in the right direction or show me how the SQL should be structured to achieve this?</p>
  
  <p>SQL:</p>
  
  <pre><code>    SELECT plan_master.plan_id,
         plan_master.date_submitted,
         plan_master.filename,
         initiative_master.plan_id,
         initiative_master.NAME,
         initiative_master.acad_priority_1,
         funding.initiative_id,
         funding.beginning_fiscal_year
  FROM   plan_master
         JOIN initiative_master
                 ON plan_master.plan_id = initiative_master.plan_id
         JOIN funding
                 ON initiative_master.initiative_id = funding.initiative_id  
  ORDER BY Filename
  
  
  
  
  |plan_id|date_submitted|filename|plan_id|NAME|acad_priority_1|initiative_id|begginning_fiscal_year|
  |16F44FFE-5434-4E52-9D9A-F45C0A49D8E2|2018-12-03|1.txt|16F44FFE-5434-4E52-9D9A-F45C0A49D8E2|Space Utilization framework|false|8CCE0311-0E3C-467D-B675-04817A473056|2018/2019
  |16F44FFE-5434-4E52-9D9A-F45C0A49D8E2|2018-12-03|1.txt|16F44FFE-5434-4E52-9D9A-F45C0A49D8E2|Space Utilization framework|false|8CCE0311-0E3C-467D-B675-04817A473056|2019/2020
  |16F44FFE-5434-4E52-9D9A-F45C0A49D8E2|2018-12-03|1.txt|16F44FFE-5434-4E52-9D9A-F45C0A49D8E2|Space Utilization framework|false|8CCE0311-0E3C-467D-B675-04817A473056|2020/2021
  </code></pre>