一个稍有难度的ASP+ACCESS查询，求解

我来解答这个 有nd的问题
TABLE表            
a    b    c    d
----------------
A    1    8    5
B    6    2    7
C    4    9    3
--------------------------
sql 语句
--------------------------
select a,b from
(select a,b from Table_1
UNION ALL
select a,c from Table_1
UNION ALL
select a,d from Table_1) as t order by b
----------------------------
结果
a             1         
b             2         
c             3         
c             4         
a             5         
b             6         
b             7         
a             8         
c             9