Question

如何用sql 语句将两个数据表相同字段合并成另外一个表

Answer 1

select a,b,c from tb1
union (all)�0�2
select d,e,f from tb2
要去除重复的用union，不去除得话用union alld,e,f的数据类型要可以转换成a,b,c

Answer 2

Create Table x as (Select a.field,b.field from a,b where a.id = b.id)

Answer 3

select * into tb3 from (select a,b,c,d,e from tb1union all select a,b,c,d,e from tb2 ) tbx