Pull Data from One Table to Another

[cfr]

What would be the propper SQL code for a query if I want to copy certain data from one table to an empty table that has different field names? This is probably simple, but I new to SQL and Access.

Thanks for your time.

 

[araskas]

create an append query using the query qizard.
Look for some examples on using teh append query. It is really very simple.