title: Avoid repetition in SQL Query
body: <p>I have three tables.</p>
  
  <p><strong>Project</strong></p>
  
  <pre><code>Project ID | Project Name
           1 | Project 1
           2 | Project 2  
  </code></pre>
  
  <p><strong>Enhancement Pjt</strong></p>
  
  <pre><code>Enh ID | Enh Name   | Project ID
      1  | Enh Name 1 | 1
      2  | Enh Name 2 | 1
      3  | Enh Name 3 | 2
  </code></pre>
  
  <p><strong>Support Table</strong></p>
  
  <pre><code>Supp. ID | Supp. Proj Name | Project ID
         1 | Supp Name 1     | 1
         2 | Supp Name 2     | 2
         3 | Supp Name 3     | 2
  </code></pre>
  
  <p>I want to create a query table which lists all the Projects and their associated Enh. Projects and Support Projects. I used joins but the result contains repeating columns in the support table which is quite confusing for a report.</p>