Automatically number rows in Select自動採番

Use rownum, number count from 1;

Example:

insert into table2
select rownum, t3.name
from table1 t1
join table3 t3 on t1.id=t3.id