求SQL汇总语句..请帮忙

zxmsgdhr

表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

请帮忙

821105

Select * From
   (Select id,name as 'Name2','' as 'Name3' from 表1
    union all
    Select idmc as 'id',name2,name3 from 表2) a
   order by a.id

michealhenry

--如果name列是可以排序的话
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

wgfxman

select id,Name,Name2,Name3' from
(
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

wgfxman

select id,Name,Name2,Name3 from
(
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

前面多了个'

pguppgdn

select * from
( select id,name,'' from table1
  union all
select idmc,name2,name3 from table2

) a
order by id

3972500

select tmp.* from (select id,name as name2, '' as name3
union
select idmc as id,name2,name3
order by name2) tmp
order by tmp.id

3972500

漏了，呵呵
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

lancelover

select id,name,name2 from
(
select id,name,'' as name2 as sort from ta1
union
select idmc,name2,name3 from ta2
)tmp
order by id