INSERT INTO MyDestinationTable (MyField1, MyField2, MyField3)If your two tables have the exact same structure you may omit the list of columns in both the INSERT and SELECT sub statements, but it doesn't hurt to be explicit.
SELECT MyField1, MyField2, MyField3 FROM MySourceTable