1，将查询结果作为临时表：
select * from ( select a.id as id,b.name as name from t_a a, t_b b where a.id=b.id) as tmp
?
2，将查询结果插入到目表表：
2.1，表存在
insert into 目表表 select * from 表 where 条件
2.2，表不存在
select * into 目标表 from 表 where 条件
?
3，应用：N个表关键查询的结果存到t_new
insert into t_new select * from ( select a.id as id,b.name as name from t_a a, t_b b where a.id=b.id) as tmp
?