title: Mysql UNION Tables MAX date
body: <p>I have two tables calls and tasks. I want to get the farthest date which ever is from both tables. The result will be one date that is the Maximum of all.</p>
  
  <p>So basically want to join the quires below</p>
  
  <blockquote>
    <p>SELECT   <code>id</code>,   MAX(<code>date_due</code>) FROM tasks WHERE 
        <code>parent_id</code> = '35'
        AND date_due > CURDATE()</p>
    
    <p>SELECT   <code>id</code>,   MAX(<code>date_start</code>) FROM calls WHERE 
        <code>parent_id</code> = '35'
        AND date_start > CURDATE()</p>
  </blockquote>
  
  <p>These will result the max date from each table but how do i get single record which is the Highest Date.</p>