title: How to insert a SQL date-filtered query into another SQL query
body: <p>My goal is to have an output with dates only between Aug 17 to Aug 31. I was able to create a query that does that but the issue I'm having is how to insert it into an existing query without breaking it.</p>
  
  <p>This is the working query that sorts the dates that I need:</p>
  
  <pre><code>SELECT *  FROM OUTING
  WHERE OUT_DATE BETWEEN '27-AUG-16' AND '31-AUG-16';
  </code></pre>
  
  <p>And this is the code that I want to insert it into:</p>
  
  <pre><code>SELECT TOUR. TOUR_NAME, OUTING. OUT_DATE , 'Leaving: '||OUT_STARTLOC||' and 
  Arriving: '||OUT_ENDLOC AS "LOCATIONS"
  FROM OUTING JOIN TOUR ON OUTING.TOUR_ID = TOUR.TOUR_ID
  ORDER BY OUT_DATE, TOUR_NAME
  </code></pre>
  
  <p>How would I be able to insert my sort by date query correctly?</p>