ACCESS中的Update语句不支持Select的解决办法执行
比如ACCESS中执行SQL语句:
UPDATE HN_news AS a SET typeid = (select clid from HN_newscla b where a.class=b.id)
WHERE typeid=0;
报"操作必须使用一个可更新的查询。"
解决发法用INNER JOIN:
UPDATE HN_news AS a INNER JOIN HN_newscla AS b ON a.class=b.id SET typeid = b.clid
WHERE typeid=0;