title: Search by date even if date is not in table
body: <p>I make a select in MySQL and  search between 2 dates and make a count of elements by date and it works fine but, if a date has no records it does not appear, what I'm looking for is something like this:</p>
  
  <p>Column date  /    Count</p>
  
  <ul>
  <li>2017-01-01 /   1 </li>
  <li>2017-01-02 /   2 </li>
  <li>2107-01-03 /    0     *Date without records </li>
  <li>2017-01-04 /     1</li>
  </ul>
  
  <p>What I get</p>
  
  <ul>
  <li>2017-01-01 /   1</li>
  <li>2017-01-02 /   2</li>
  <li>2017-01-04 /   1</li>
  </ul>
  
  <p>2017-01-03 does not show because has no records</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT I.FechaInstalacion, count(Case when I.ServicioId = 1 then 1 end) as P
  FROM Instalacion I
  WHERE I.EmpleadoId = 4 and I.FechaInstalacion&gt;='2018-01-01' and 
  I.FechaInstalacion&lt;= '2018-01-31'
  group by I.FechaInstalacion
  </code></pre>
  
  <p>Thank you!</p>