I found this article on one of my favorite sites on how to insert new records using an embedded SELECT statement. Here is an example:
INSERT california_authors (au_id, au_lname, au_fname)
SELECT au_id, au_lname, au_fname
FROM authors
WHERE State = 'CA'
http://www.sqlteam.com/article/using-select-to-insert-records