SQL表合并 表1:h_app_gb,字段有:timepoint,a,a+,b,b+,c,c+ 表2:h_app_gb_123,字段有:timepoint,a,a+,b,b+

SQL表合并 表1:h_app_gb,字段有:timepoint,a,a+,b,b+,c,c+ 表2:h_app_gb_123,字段有:timepoint,a,a+,b,b+

select a,a+,b,b+,c,c+ from 表1 order by timepoint desc
union
select a,a+,b,b+,'' c,'' c+ from 表2 order by timepoint desc

select * from 表1
union all
select *,'','' from 表2

如果你要把表2的记录添加到表1中：
insert into 表1 (timepoint,a,[a+],b,[b+]) select timepoint,a,[a+],b,[b+] from 表2 order by timepoint desc
如果是要显示两张表记录结果：
select timepoint,a,[a+],b,[b+],c,[c+] from 表1
union
select timepoint,a,[a+],b,[b+],'' c,'' [C+] from 表2 order by timepoint desc
有问题可以追问或Hi我。