这个查询要怎么写？

[yinsuxia]

表结构：
id，列1，列2，列3
1 2 3 4
2 3 4 5

我想查出来的结果：
id 列1
id 列2
id 列3

比如：
1 2
1 3
1 4

2 3
2 4
2 5

就按上面的结果的格式
其实就是把一行里面的数据拆开，不知有什么好方法可以实现呢？

[guguda2008]

SELECT ID,[列1] FROM TB
UNION ALL
SELECT ID,[列2] FROM TB
UNION ALL
SELECT ID,[列3] FROM TB

[AcHerat]

select id,col1
from tb
union all
select id,col2
from b
union all
select id,col3
from tb

[快溜]

SELECT ID,[列1] FROM TB
UNION ALL
SELECT ID,[列2] FROM TB
UNION ALL
SELECT ID,[列3] FROM TB
order by id

[清海扬波]

select id,列1
union all
select id,列2
union all
select id,列3

[guguda2008]

SELECT * FROM (
SELECT ID,[列1] FROM TB
UNION ALL
SELECT ID,[列2] FROM TB
UNION ALL
SELECT ID,[列3] FROM TB
) T
ORDER BY ID

[孤独剑_LPZ]

select id,列1 from biao
union
select id,列2 from biao
union
select id,列3 from biao

[pxy_83]

SELECT * FROM (
SELECT ID,[列1] FROM TB
UNION ALL
SELECT ID,[列2] FROM TB
UNION ALL
SELECT ID,[列3] FROM TB
) T
ORDER BY ID

[yeyerl]

帮顶！帮顶！