[VB.NET]使用ODBC更新DBF表时提示操作符号丢失 怎么弄啊

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
使用ODBC更新DBF表时提示操作符号丢失 怎么弄啊
UPDATE Table2
SET A = Table1.A
FROM Table2 INNER JOIN Table1 ON Table2.A = Table1.A

从表1更新表2 在SQL可以执行成功 但是用来更新DBF表就会提示 "语法错误(操作符丢失) " 这个怎么弄啊

也就是DBF从A表更新B表应该用什么语句啊???
__________________________________________________________________________
UPDATE Table2
SET Table2.A = Table1.A
FROM Table2 INNER JOIN Table1 ON Table2.A = Table1.A
__________________________________________________________________________