title: MySQL INNER JOIN multiple rows same value
body: <p>Both of the following tables have 2 entries for the same player.</p>
  
  <p>Table punishment :
  <a href="https://i.stack.imgur.com/cFufL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cFufL.png" alt="table punishment"></a>
  Table cooldown :
  <a href="https://i.stack.imgur.com/J0C7n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J0C7n.png" alt="table cooldown"></a></p>
  
  <pre><code>SELECT punishment_id, punishment.reason, cooldown.id, cooldown.time_left FROM player INNER JOIN punishment ON player.most_uuid=punishment.most_uuid INNER JOIN cooldown ON player.most_uuid=cooldown.most_uuid WHERE player.most_uuid=2941535451391147758
  </code></pre>
  
  <p>In the result of this query I have some kind of "duplicated" rows.
  I get 4 rows when I'd like to have just 2 with the essentials values inside.</p>
  
  <p>Result from the query<a href="https://i.stack.imgur.com/lY8BI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lY8BI.png" alt="result of the query"></a> </p>
  
  <p>I need all the values present in the rows, but as you can see there are pairs of rows with the exact same value twice.</p>
  
  <p>Is there a possibility of merging them to actually have 2 like this (and not having duplicated values):</p>
  
  <p><a href="https://i.stack.imgur.com/7gv1L.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7gv1L.png" alt="enter image description here"></a></p>