title: An explanation with SQL query
body: <p>I trying to get some data for my JavaFX Application from a couple of tables in database with MySQl. </p>
  
  <p>Here's the query:</p>
  
  <pre><code> select veturattable.id, veturattable.vetura,veturattable.modeli,veturattable.ngjyra,
       veturattable.targa, renttable.pagesa, hargjimettable.shuma 
          from veturattable 
       left join hargjimettable 
          on hargjimettable.veturaid= veturattable.id 
          left join renttable  
       on renttable.veturaid = veturattable.id ; 
  </code></pre>
  
  <p>Here are datas from rentable</p>
  
  <p><a href="https://i.stack.imgur.com/vYGHA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vYGHA.jpg" alt="enter image description here"></a></p>
  
  <p>And here are datas from hargjimettable</p>
  
  <p><a href="https://i.stack.imgur.com/z849L.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z849L.jpg" alt="enter image description here"></a></p>
  
  <p>So what I need is to show me this one:</p>
  
  <pre><code>veturaid | pagesa | shuma
  1        | 150    | 91
  10       | 110    | 40
  </code></pre>