SQL_insert into（把B表某些字段，插入A表某些字段）

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