using nested query to insert values into a table

how to insert values selected from another table using nested qu开发者_JS百科ery

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