title: Delphi MySql: Unknown column in where clause
body: <p>I'm using Delphi to perform a query on MySQL database.</p>
  
  <p>A simple query like:</p>
  
  <pre><code>select * from table1, table2 
  where table1.field1 = table2.field1
  </code></pre>
  
  <p>works perfectly via Navicat, but fails using delphi with error message:</p>
  
  <p>"Unknown column field1 in where clause"</p>
  
  <p>Thanks</p>