title: Unwanted result with two "Join" in SQL
body: <p>I'm currently stuck on a problem with my database. I have a table of film reviews, a table of positives and another one of negatives. These last ones are linked to the id of an review.</p>
  <p>Here are the positive and negative tables:</p>
  <p><img src="https://i.stack.imgur.com/uPvNp.png" alt="Table positives" /></p>
  <p><img src="https://i.stack.imgur.com/wRDLX.png" alt="Table negatives" /></p>
  <p>I'd like to get this result:</p>
  <p><img src="https://i.stack.imgur.com/dWvU4.jpg" alt="The result that I would like" /></p>
  <p>But I have this one instead:</p>
  <p><img src="https://i.stack.imgur.com/TJCDd.png" alt="My actual result" /></p>
  <p>Here's my SQL code to get this result:</p>
  <pre><code>SELECT positives.libelle AS positive, negatives.libelle AS negative FROM reviews LEFT JOIN positives ON positives.review_id = reviews.id LEFT JOIN negatives ON negatives.review_id = reviews.id WHERE reviews.id = 1 
  </code></pre>