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;
thanks for this sample way
great work!