新表中加入其他表的数据
如何操作..是否有一条命令可以直接完成

例如

insert into member values ( ' ',select a1,a2,a3 from aaaa )

[解决办法]
insert into member values (select ' ',a1,a2,a3 from aaaa )
或者
insert into member values (select a1,a2,a3 from aaaa union all select b1,b2,b3 from bbbb)