SELECT INTO 语句
SELECT INTO 语句从一个表中选取数据,然后把数据插入另一个表中。
SELECT INTO 语句常用于创建表的备份复件或者用于对记录进行存档。
eg:
select * into Persons_backup from Persons
select LastName,FirstName into Person_backup From Persons
IN子句可用于向另一个数据库中拷贝表
eg:
select * into Persons IN 'Backup.mdb' from Persons
带有where子句
select LastName,Firstname into Persons_backup from Persons where City='Beijing'
被连接的表
select Persons.LastName, Orders.OrderNo
into Persons_order_backup
From Persons
Inner join Orders
ON Persons.Id_P=Orders.Id_P