title: Showing date even zero value SQL
body: <p>I have SQL Query:</p>
  
  <pre><code>SELECT Date, Hours, Counts FROM TRANSACTION_DATE
  </code></pre>
  
  <p><strong>Example Output:</strong> </p>
  
  <pre><code>     Date        | Hours | Counts
     ----------------------------------
     01-Feb-2018   |   20  |   5 
     03-Feb-2018   |   25  |   3 
     04-Feb-2018   |   22  |   3 
     05-Feb-2018   |   21  |   2 
     07-Feb-2018   |   28  |   1 
     10-Feb-2018   |   23  |   1 
  </code></pre>
  
  <p>If you can see, there are days that missing because no data/empty, but I want the missing days to be shown and have a value of zero: </p>
  
  <pre><code>     Date        | Hours | Counts
     ----------------------------------
     01-Feb-2018   |   20  |   5 
     02-Feb-2018   |    0  |   0
     03-Feb-2018   |   25  |   3 
     04-Feb-2018   |   22  |   3 
     05-Feb-2018   |   21  |   2
     06-Feb-2018   |    0  |   0 
     07-Feb-2018   |   28  |   1 
     08-Feb-2018   |    0  |   0
     09-Feb-2018   |    0  |   0
     10-Feb-2018   |   23  |   1 
  </code></pre>
  
  <p>Thank you in advanced.</p>