title: Spread a table in a date time interval
body: <p>Hello everyone it's been some days that I use sql to make analysis and I meet all kinds of problems that I solves thanks to your forum.</p>
  
  <p>Now I'd like to create a view that recuperates the interval of time and shows in detail the dates in this interval.</p>
  
  <p>I have the following table:</p>
  
  <p><img src="https://i.stack.imgur.com/bpBwN.png" alt="enter image description here"></p>
  
  <p>And I want to create the view that displays the result:</p>
  
  <p><img src="https://i.stack.imgur.com/FlSzK.png" alt="enter image description here"></p>
  
  <p>For example in the player1 MyTable to play five days from 01/01/2012
    to 05/01/2012. So the view displays 5 lines for player1 with the date 01/01/2012, 02/01/2012, 03/01/2012, 04/01/2012, 05/01/2012.</p>
  
  <p>Thank you in advance for your help.</p>