title: MySQL - Select Query with junction table to one row
body: <p>i have the following tables:</p>
  
  <pre><code>**entries**
  entry_id | date | engineer | project
  
  **entries_allowanes_map**
  entry_id | allowance_id
  
  **allowances**
  allowance_id | allowance_name
  </code></pre>
  
  <p>I want to create a SELECT query that will give the following result:</p>
  
  <pre><code>entry_id | date | engineer | project | allowance_name1 | allowance_name2 | allowance_name_n...
  </code></pre>
  
  <p>The queries I have tried return a row for each allowance an entry has registered with. I want just one row with all allowances attached to it.</p>
  
  <p>Thanks in advance </p>