title: SQL query inner join with 0 values
body: <p>I have this table:</p>
  
  <pre><code>idSection   | idQuestion    | title     | enunciation | idScale
  1           | 1             | title 1   | question 1  |    3      
  1           | 1             | title 1   | question 1  |    3      
  1           | 1             | title 1   | question 1  |    3      
  1           | 1             | title 1   | question 1  |    2
  1           | 1             | title 1   | question 1  |    5
  1           | 2             | title 2   | question 2  |    1      
  1           | 2             | title 2   | question 2  |    3      
  1           | 3             | title 3   | question 3  |    1      
  </code></pre>
  
  <p>And have this table:</p>
  
  <pre><code>idScale   |       name 
     1      |      Very Bad
     2      |         Bad
     3      |         Good
     4      |      Very Good
     5      |      Excellent
  </code></pre>
  
  <p>I wanted a table like this:</p>
  
  <pre><code>idSection   | idQuestion    | title     | enunciation | Total  | Name
  1           | 1             | title 1   | question 1  |    0   |  Very Bad
  1           | 1             | title 1   | question 1  |    0   |  Bad
  1           | 1             | title 1   | question 1  |    3   |  Good
  1           | 1             | title 1   | question 1  |    0   |  Very Good
  1           | 1             | title 1   | question 1  |    1   |  Excellent
  1           | 2             | title 2   | question 2  |    0   |  Very Bad
  1           | 2             | title 2   | question 2  |    1   |   Bad
  1           | 2             | title 2   | question 2  |    3   |  Good 
  1           | 2             | title 2   | question 2  |    0   |  Very Good
  1           | 2             | title 2   | question 2  |    0   |  Excellent
  </code></pre>
  
  <p>The query:</p>
  
  <pre><code>SELECT 
      t1.idSection, t1.idQuestion, t1.title, t1.enunciation, 
      COUNT(t1.idScale) as Total, t2.name 
  FROM 
      table1 AS t1
  INNER JOIN 
      table2 as t2 ON t2.idScale = t1.idScale
  GROUP BY 
      t1.idSection, t1.idQuestion, t1.title, t1.enunciation, t2.name
  </code></pre>
  
  <p>The result of this is query:</p>
  
  <pre><code>idSection   | idQuestion    | title     | enunciation | Total  | Name
  1           | 1             | title 1   | question 1  |    3   |  Good
  1           | 1             | title 1   | question 1  |    1   |  Excellent
  1           | 2             | title 2   | question 2  |    1   |   Bad
  1           | 2             | title 2   | question 2  |    3   |  Good 
  </code></pre>
  
  <p>The problem with this is that query values ​​that are 0 don't appear.</p>