CODE EXAMPLE FOR SQL

sql insert multiple rows from another table

INSERT INTO customer (first_name, last_name)
SELECT fname, lname
FROM list_of_customers
WHERE active = 1;