using nested query to insert values into a table

Question

how to insert values selected from another table using nested query

Answer 1

may be following will help you :

INSERT california_authors (au_id, au_lname, au_fname)
SELECT au_id, au_lname, au_fname
FROM authors
WHERE State = 'CA'

more : Using INSERT and SELECT