insert into table1(field1) select field1 from table2
insert into table1(field2) select field2 from table3
insert into table1(field3) select field3 from table3
....
insert into table1(field2) select field2 from table3
insert into table1(field3) select field3 from table3
....
select (select top 1 字段1 from 表1)
,(select top 1 字段2 from 表2)
,(select top 1 字段3 from 表3)
同意,宝宝的也可以实现