copy record from one table to another (identical)

[fgeorge]

how can i copy a record with 15 fields from one table to another identical table withot having to do a LONNNGGG insert by passing 15 variables?
any way round this?

 

[dickiebird]

insert tableb select * from tablea (where condition(s) = true)

Dickie Bird (-)))

 

[Jamfool]

--creates the destination table
SELECT *
INTO table_new
FROM table_old


--if the table exists alreay
INSERT INTO table_new
SELECT *
FROM table_old