insert into table_a(field_a1,field_a2,field_a3) select field_b1,field_b2,field_b3) from table_b
update 表二 set 字段B=(select 字段A from 表一) where 条件=?