求一SQL语句,双表联查
A表:

id name
----------
01 aaa
02 bbb

B表:

id name
-----------
11 ccc
12 ddd

查询结果:

id name
----------
01 aaa
02 bbb
11 ccc
22 ddd

这个语句怎么写,谢谢

[解决办法]
select * from (select * from a
union all
select * from b ) a order by id