关于在access更新时用到子查询，还请大家快来帮帮我

nousen

在access中   如何实现pl/sql 中 update用法如：

update  table1  set(col1,col2,col3 ) = (select col1,col2,col3 from table2 where col4 = '001')

where  table1.col4 = '001' ;

sea.er

UPDATE table1 INNER JOIN table2 ON table1.col4 = table2.col4 SET table1.col1 = [table2]![col1], table1.col2 = [table2]![col2], table1.col3 = [table2]![col3]

WHERE (((table1.col4)="0001"));