Seeking SQL summary statement.. please help

zxmsgdhr

Table 1
id name
1 a
2 b
3 c


Table 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

The result to be obtained:
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

please help

821105

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

michealhenry

--If the name column can be sorted
select id,name,'' as name2 from table1
union
select idmc,name2,name3 from table2
order by name

--If it cannot be sorted
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 Table 1
union all
Select idmc as id,'' as NAME,name2,name3,1 as sort from Table 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 Table 1
union all
Select idmc as id,'' as NAME,name2,name3,1 as sort from Table 2
) t
order by id,sort,Name2

There is one more in front of'

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

Missed, ha ha
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