Help with Insert Statement!!

Can somebody help me with an Insert statement. I'm trying to insert data from one table into another table.
My structure that i wrote isn't working at all.
Please Helpif both tables have the same structure:
insert into Another_Table
select * from One_Table

if you wish to only insert data from a few attributes:
insert into Another_Table (First, Last, Middle)
select FirstName, LastName, MiddleName from One_Table

Of course you can add a where clause when needed