SQL Query to move multiple records from one Table to another in SQL Server

I have two tables which contain:

FIRST TABLE           SECOND TABLE

ID                          ID LASTNAME               FIRSTTABLEID FIRSTNAME              LASTNAME MIDDLENAME            FIRSTNAME DATANAME               MIDDLENAME CONTENTTYPE          DATANAME DATA                      CONTENTTYPE                               DATA

My question is how can I move the the File into another table? Thank you