title: visual foxpro - need to update table from another table
body: <p>I have 2 dbf tables and I need to update the 1st table based from the 2nd table values.
  I am able to do it in SQL server and I need help on Visual Foxpro.</p>
  
  <p>Here's my foxpro command:</p>
  
  <p>=========================================================</p>
  
  <pre><code>use table1
  
  use table2
  
  UPDATE table1 
  
  SET table1.name = table2.name 
  
  from table1 inner join table2 
  
  on table1.id = table2.id 
  
  WHERE table1.dsdate &gt;= {^2011-04-13} and table1.dsdate &lt;= {^2012-04-12}
  </code></pre>
  
  <p>=========================================================</p>
  
  <p>Please help me, thanks very much!</p>