表1
id name
1 a
2 b
3 c
表2
idmc name2 name3
1 a1 hg
1 a2 kj
1 a3 fd
1 a4 tr
2 b1 uy
2 b2 s
3 c4 jk
3 c6 ty要得到的结果:
1 a
1 a1 hg
1 a2 kj
1 a3 fd
1 a4 tr
2 b
2 b1 uy
2 b2 s
3 c
3 c4 jk
3 c6 ty请帮忙
id name
1 a
2 b
3 c
表2
idmc name2 name3
1 a1 hg
1 a2 kj
1 a3 fd
1 a4 tr
2 b1 uy
2 b2 s
3 c4 jk
3 c6 ty要得到的结果:
1 a
1 a1 hg
1 a2 kj
1 a3 fd
1 a4 tr
2 b
2 b1 uy
2 b2 s
3 c
3 c4 jk
3 c6 ty请帮忙
(Select id,name as 'Name2','' as 'Name3' from 表1
union all
Select idmc as 'id',name2,name3 from 表2) a
order by a.id
select id,name,'' as name2 from table1
union
select idmc,name2,name3 from table2
order by name--如果不可以排序
select id,name,name2 from
(
select id,name,'' as name2,0 as sort from table1
union
select idmc,name2,name3,1 from table2
)tt
order by id,sort
(
Select id,name as Name,'' as Name2,'' as Name3,0 as sort from 表1
union all
Select idmc as id,'' as NAME,name2,name3,1 as sort from 表2
) t
order by id,sort,Name2
(
Select id,name as Name,'' as Name2,'' as Name3,0 as sort from 表1
union all
Select idmc as id,'' as NAME,name2,name3,1 as sort from 表2
) t
order by id,sort,Name2前面多了个'
( select id,name,'' from table1
union all
select idmc,name2,name3 from table2) a
order by id
union
select idmc as id,name2,name3
order by name2) tmp
order by tmp.id
select tmp.* from (select id,name as name2, '' as name3 from table1
union
select idmc as id,name2,name3 from table2
order by name2) tmp
order by tmp.id
(
select id,name,'' as name2 as sort from ta1
union
select idmc,name2,name3 from ta2
)tmp
order by id