表a{ id(int),a(int)} id为主键.自增
表b{id(int),b(int)}id为主键.自增
a:
id a
1 1
2 2
3 3
b:
id b
4 4
5 5
6 6想在查询分析器用sql语句 select 变成下面这样id c
1 1
2 2
3 3
4 4
5 5
6 6求此语句!谢谢.
表b{id(int),b(int)}id为主键.自增
a:
id a
1 1
2 2
3 3
b:
id b
4 4
5 5
6 6想在查询分析器用sql语句 select 变成下面这样id c
1 1
2 2
3 3
4 4
5 5
6 6求此语句!谢谢.
union all
select * from b
union
select * from b
a:
id a a1
1 1 1
2 2 2
3 3 3
b:
id b b1
4 4 4
5 5 5
6 6 6
变成
id c d
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6?列名为c和d
union all
select id,b as c from tb_b这样就可以了.
insert into a values(1 ,1, 1)
insert into a values(2 ,2, 2)
insert into a values(3 ,3, 3)
create table b(id int,b int,b1 int)
insert into b values(4 ,4 ,4)
insert into b values(5 ,5 ,5)
insert into b values(6 ,6 ,6)
goselect id , c = a , d = a1 from a
union all
select id , c = b , d = b1 from bdrop table a , b/*
id c d
----------- ----------- -----------
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6(所影响的行数为 6 行)
*/