How do you insert selected rows from
INSERT INTO table_target SELECT * FROM table_source
Either you list all of the fields you want in the insert...select, or you use something else externally to build the list for you.
SQL does not have something like
SELECT * except somefield FROM, so you'll have to bite the bullet and write out the field names.