直接insert into ... select ... 就行了。例如,从A、B查询结果,插入到C表:insert into C(C1,C2)select A.C1, B.C2 from A inner join Bon A.ID = B.ID