Inserting two tables together with no Id or UNIQUE anything
Should be:

insert into table1
select * from table2
except
select * from table1;


You could also use:

select * 
from table2 
where Name not in (select Name from table1)


This works too (assuming Name cannot be NULL).

The difference is that the except version delivers all rows that are not the same whereas the not in query delivers all rows where the name does not exist. Up to you to decide if this is what you need.