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

例如

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)