大姐帮帮小弟，关于表连接的有关问题，多谢a _Sql Server

各位大哥大姐帮帮小弟，关于表连接的问题，谢谢a !
表A
id
1
2
表B
id
1
3
表C
id
4
5
-------------------------
请问怎么连接，结果就是：
id
1
2
3
4
5
-------------------

帮帮忙啊！

------解决方案--------------------

SQL code

select * from aunionselect * from bunionselect * from c
------解决方案--------------------
SQL codeselect a.id aid,b.id bid,c.id cidfrom (select * from @表A where id = 2) a full join @表B b on a.id = b.id            full join @表C c on a.id = c.id