Question

关于SQL的一个问题，请会的人帮助，好的话追加分数

select * from table1 t1,table2 t2 where t1.a1=t2.a1

问题：将上述查询结果插入到第三张表中 或 将上述查询结果的某些字段插入到第三张表中

用一条语句完成怎么写？？？？

Answer 1

insert into table3 select * from table1 t1,table2 t2 where t1.a1=t2.a1
或
insert into table3(uname,pass) select uname,pass from table1 t1,table2 t2 where t1.a1=t2.a1.a1

Answer 2

insert into tmptable from select ....

Answer 3

insert into table3 select * from table1 as t1,table2 as t2 where t1.a1=t2.a1