简单SQL语句问题

[yj1804]

select * from tablename into newtablename
我知道这个可以把一个表中的记录读到新表中
现在我需要把一个表中的一些记录读到一个已经存在的表了，有没有和上面类是的办法，还是只能一条一条读出来，然后插入？

[maoyesky]

Insert into yournewtable (field1,field2,...) select field1,field2,... from
youroldtable where ...

[zhbname]

insert into 表名一(fieldid,fieldname,...)
select (表名2.fieldid,表名2.fieldname,...)
from 表名2
where 条件

[愉快的登山者]

结构一样的两个表：
insert into newtablename
select * from tablename
where 条件

[txlicenhe]

insert newTablename select * from tableName

[dafu71]

Insert yournewtable (field1,field2,...) select field1,field2,... from
youroldtable where ...

[大力]

select * into newtable from table

[eminena]

insert newTablename select * from tableName