SQL语句。。。。。

[bluesky23]

insert into table1 values(select * from table2)
我想把table2中的数据全部追加到table1中，
这句怎么不对？
应该如何改？
急。。。。。

[fu256]

insert into table1 select * from table2
or
select * into tablel from table2

[lzj34]

真晕
db.Execute "INSERT INTO table1 SELECT * FROM table2"

[aohan]

如果表结构相同，则用
insert into tabela
select * from tabelb

如果表结构不同，则需要对应好
insert into tabela ( fields1,fields2...)
select fields1,fields2... from tabelb

[online]

insert into table1(id,mc,mx,mv)
select id,mc,mx,mv from table2

[huangjianyou]

Sub InsertIntoX1()

Dim dbs As Database

Set dbs = OpenDatabase("Northwind.mdb")

dbs.Execute " INSERT INTO Customers " _
& "SELECT * " _
& "FROM [New Customers];"

dbs.Close

End Sub

Sub InsertIntoX2()

Dim dbs As Database

Set dbs = OpenDatabase("Northwind.mdb")

dbs.Execute " INSERT INTO Employees " _
& "(FirstName,LastName, Title) VALUES " _
& "('Harry', 'Washington', 'Trainee');"

dbs.Close

End Sub

^_^

[tztz520]

db.Execute "INSERT INTO table1 SELECT * FROM table2"

[tztz520]

一句代码就可以了

[creazyfish]

online(龙卷风V3.0--笑傲江湖)
tztz520(午夜逛街)
都是对的呵呵

[lxtlwd]

insert into table1 select * from table2

[pweixing]

如果全部插入就不要 value 了，除非你要求插入某些字段。