how to insert results of two quries with counts

i have field name 'name' in table1 and in table2
and also i have one numeric fiels in table 1 and also in another numeric field in table2 which is differant from that
now i wnat to insert the result of the queris such as
select sum(numericfield1) from table1 where distinct name
select sum(numericfield2) from table2 where distinct name
at the end the two name fields to be equal
this entire data to be saved in a new table

Try

INSERT INTO emptytable(name,numericfield)
SELECT name1, sum(numericfield1+numericfield2) FROM table1, table2
WHERE name1=name2
GROUP BY name1