|
biaobiao520 写道
yangguo 写道
biaobiao520 写道
SELECT a.col , a.YEAR, a.columna DATA
FROM (SELECT 'columna' col, YEAR, columna
FROM my_test) a,
(SELECT 'columnb' col, YEAR, columnb
FROM my_test) b
WHERE a.YEAR = b.YEAR
UNION ALL
SELECT b.col, b.YEAR, B.COLUMNB DATA
FROM (SELECT 'columna' col, YEAR, columna
FROM my_test) a,
(SELECT 'columnb' col, YEAR, columnb
FROM my_test) b
WHERE a.YEAR = b.YEAR;
整理了一下别名,貌似column不能用作列名
受教了
晕。。。
好像直接这么取就可以了。。。
SELECT a.col , a.YEAR, a.columna DATA
FROM (SELECT 'columna' col, YEAR, columna
FROM my_test) a
UNION ALL
SELECT b.col, b.YEAR, B.COLUMNB DATA
FROM (SELECT 'columnb' col, YEAR, columnb
FROM my_test) b
哈哈,我刚发短信给你,也是这样。
|
|