select a,b,c from tb1
union (all)�0�迟芦知2
select d,e,f from tb2
要去除重哗耐复的用union，不去除得话用union alld,e,f的数据类型要可以码消转换成a,b,c
Create Table x as (Select a.field,b.field from a,b where a.id = b.id)
select * into tb3 from (select a,b,c,d,e from tb1union all select a,b,c,d,e from tb2 ) tbx
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024