title: How to read from multiple dbf files in a single query
body: <p>I am trying the following query to read from multiple dbf files in the same folder:</p>
  
  <pre><code>"SELECT COMPNO FROM REF10,REF11,REF12,REF08,REF09 WHERE SR_NO='RDDFT000108'";
  </code></pre>
  
  <p>The above generates the following error:</p>
  
  <blockquote>
    <p>"The specified field 'COMPNO' could refer to more than one table
    listed in the FROM clause of your SQL statement."</p>
  </blockquote>
  
  <p>How can I refer more than one tables in the same query?</p>