insert into table_A([column],[column],[column]) select column,column,columnfrom table_Bwhere ...order by ...