lots of code take some code, share some code!

A very simple way of passing data from one table to another is by using the select insert statement in sql.

INSERT INTO table (forename, dayphone, address1, address2, address3, postcode, country, email)
select r.first_name r.phone_number, r.address1, r.address2, r.address3, r.post_code, r.country, r.email from table2 r;

Filed under: SQL, Snippets, SQL