表A 有3个字段abc 数据如下
a b c
1 2 3
3 3 3表A 有3个字段def数据如下
d e f
1 2 3
2 3 3
5 3 3合成表C 字段 x1 x2 x3
x1 x2 x3
1 2 3
3 3 3
1 2 3
2 3 3
5 3 3
然后根据x1排序希望给出SQL语句
a b c
1 2 3
3 3 3表A 有3个字段def数据如下
d e f
1 2 3
2 3 3
5 3 3合成表C 字段 x1 x2 x3
x1 x2 x3
1 2 3
3 3 3
1 2 3
2 3 3
5 3 3
然后根据x1排序希望给出SQL语句
select * from
(
select a,b,c from A
union all select d,e,f from B
) as tb order by tb.a
(
select a,b,c from A
union all select d,e,f from B
) as tb order by tb.a这个才是我想要的,不过谢谢了
as
(Select * from A
union
Select * from B)