title: MSQL joins including two different DATE between condition
body: <p>I have written the below query.</p>
  
  <pre><code>SELECT bmr_multi_price. * 
  FROM bmr_multi_price
  INNER JOIN bmr_rooms ON bmr_rooms.resort_id = bmr_multi_price.resort_id
  AND bmr_rooms.id = bmr_multi_price.room_id
  </code></pre>
  
  <p>For this above query i have got the below result set.</p>
  
  <p><img src="https://i.stack.imgur.com/LPDKe.png" alt="enter image description here"></p>
  
  <p>But I wanted to include the below condition to achieve the above result.</p>
  
  <pre><code>WHERE ( '08/02/2013' BETWEEN bmr_multi_price.from_date AND bmr_multi_price.to_date ) OR ( '08/03/2013' BETWEEN bmr_multi_price.from_date AND bmr_multi_price.to_date )
  </code></pre>