title: Unknown column in JOIN ON statement MySQL
body: <pre><code>SELECT * FROM `a` LEFT JOIN  `dates` ON `a.date_id`=`dates.id` AND `dates.date`&gt;'19-09-2013'
  </code></pre>
  
  <p>The above query gets <code>#1054 - Unknown column 'a.date_id' in 'on clause'</code></p>