insert into table_A([column],[column],[column])
select column,column,column
from table_B
where ...
order by ...