title: Getting Max date from multiple table after INNER JOIN
body: <p>I have two following tables</p>
  
  <pre><code>table 1)
  ID |  HOTEL ID | NAME 
  1       100      xyz 
  2       101      pqr
  3       102      abc
  
  
  table 2)
  ID | BOOKING ID | DEPARTURE DATE | AMOUNT
  1         1       2013-04-12        100
  2         1       2013-04-14        120
  3         1       2013-04-9          90
  4         2       2013-04-14        100
  5         2       2013-04-18        150
  6         3       2013-04-12        100
  </code></pre>
  
  <p>I want to get reault in mysql such that it take the row from table two with MAX DEPARTURE DATE.</p>
  
  <pre><code>ID | BOOKING ID | DEPARTURE DATE | AMOUNT
  2         1       2013-04-14        120
  5         2       2013-04-18        150
  6         3       2013-04-12        100
  </code></pre>