title: how to don't display duplicate with left join
body: <p>I have 4 tables: </p>
  
  <pre><code>client: (id, organisme, nom, adresse)
  
  lot: (idLot, id, objetLot, prix)
  
  option: (idOption,idLot,id,prixOption)
  
  variante: (idVariante, idLot, prixVariante)
  </code></pre>
  
  <p>I would like to display all records from <code>client</code> with the different <code>price</code> about <code>lot</code>. </p>
  
  <p>But sometime I got some options on <code>lot</code> and or some <code>variante</code> on <code>lot</code>.</p>
  
  <p>Like this :
  <a href="https://i.stack.imgur.com/dwmGQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dwmGQ.png" alt="enter image description here"></a></p>
  
  <p>But the problem is that I got this : 
  <a href="https://i.stack.imgur.com/uYt8Y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uYt8Y.png" alt="enter image description here"></a></p>
  
  <p><em>I show you my request :</em> </p>
  
  <pre><code>SELECT C.*, L.*, O.*, V.*
  FROM 
    client as C
    LEFT JOIN lot as L 
      ON C.id = L.id
    LEFT JOIN option2 as O 
      ON O.id = C.id 
    LEFT JOIN variante as V 
      ON V.id = C.id 
  WHERE 
    nomDossier LIKE '%$mc%';
  </code></pre>