Syntax error on simple update query

2018-07-03 23:47:15

This question already has an answer here:

How can I do an UPDATE statement with JOIN in SQL? 14 answers

连接更新的MS-Access语法如下所示：

UPDATE table1 INNER JOIN table2 
ON table1.ID = table2.id
SET table1.family = table2.family

您使用Access的语法错误：

UPDATE table1 INNER JOIN table2 
      ON table1.ID = table2.id
SET Table1.family = table2.family;

尝试这个：

UPDATE table1 INNER JOIN table2 ON table1.id = table2.id 
SET table1.family = table2.family;

链接地址: http://www.djcxy.com/p/94666.html