title: Getting minimum price from other table using left join
body: <p>I am fetching data form two tables, <em>tour</em> and <em>tour_price</em> using left join, But from pricing table i am not able to fetch <em>minimum price</em>.</p>
  
  <p><strong>Here is my query</strong></p>
  
  <pre><code>SELECT t1.id,t1.tour_title,t2.price 
  FROM tours t1 
  LEFT JOIN tour_dates t2 ON t1.id=t2.tour_id 
  WHERE t1.status = '1' AND ( t2.price between 40 AND 100 ) 
  GROUP BY t2.tour_id 
  ORDER BY t2.price DESC
  </code></pre>
  
  <p>I think there is minor change i need, but couldn't figure out.</p>
  
  <p>please provide some help.
  Thank you.</p>