Access中如何用INSERT INTO TABLE1 SELECT * FROM TABLE2

Access中如何用INSERT INTO TABLE1 SELECT * FROM TABLE2
---------------------------------------------------------------

INSERT INTO tb_a ( field )
SELECT tb_b.field
FROM tb_a;
---------------------------------------------------------------

If the structure of table1 is same to table2's,
in acess, U can use as yours:
INSERT INTO TABLE1 SELECT * FROM TABLE2
---------------------------------------------------------------

在进行
INSERT INTO TABLE1 SELECT * FROM TABLE2
时,要求TABLE1和TABLE2的结构要一样。
否则,你就要在两个表中都要写出字段。你试试!

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus