Issue while fetching dates between range <p>I have two tables. One is hall which is having following schema. <a href="https://i.stack.imgur.com/lAJGj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lAJGj.png" alt="Hall Table"></a></p> <p><a href="https://i.stack.imgur.com/rHg81.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rHg81.png" alt="Events Table"></a></p> <p>One hall can have many events.I want halls which are available between two dates.For example halls between 2016-09-10 and enddate = 2016-09-15. I want all the halls which are not booked for the whole range of dates i.e 10,11,12,13,14,15. </p>