这两个更新语句错在哪里
update article,Communication_Network set source=[size] where article.t10=Communication_Network.[file] and classid=217
第 1 行: ', ' 附近有语法错误。
update article set source=[size] inner join Communication_Network on article.t10=Communication_Network.[file] where classid=217
在关键字 'inner ' 附近有语法错误。
------解决方案--------------------update article set source=[size] from Communication_Network where article.t10=Communication_Network.[file] and classid=217
------解决方案--------------------第二个
update article set source=[size] from article inner join Communication_Network on article.t10=Communication_Network.[file] where classid=217