原本2条sql查询后输出到txt文本的格式是这样的
id name
1 一
2 二
s_id s_name
3 三
4 四
如何才能将第一条查询结果完毕后,第二条的查询结果跟在他的右面?像这样
id name | s_id s_name
1 一 | 3 三
2 二 | 4 四请高手帮帮忙,谢了
id name
1 一
2 二
s_id s_name
3 三
4 四
如何才能将第一条查询结果完毕后,第二条的查询结果跟在他的右面?像这样
id name | s_id s_name
1 一 | 3 三
2 二 | 4 四请高手帮帮忙,谢了
SELECT '1' AS IDD ,'ONE' AS NAMEE FROM DUAL
UNION ALL
SELECT '2' AS IDD ,'TWO' AS NAMEE FROM DUAL
),
TEST2 AS (
SELECT '3' AS s_id ,'THREE' AS s_name FROM DUAL
UNION ALL
SELECT '4' AS s_id ,'FOUR' AS s_name FROM DUAL
)
SELECT IDD, NAMEE, CUP, s_id, s_name
FROM (SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY T1.IDD) AS RN, T1.*
FROM TEST1 T1) A
INNER JOIN (SELECT '|' AS CUP, RN, s_id, s_name
FROM (SELECT ROW_NUMBER() OVER(ORDER BY T2.s_id) AS RN,
T2.*
FROM TEST2 T2)) B ON A.RN = B.RN)自己整理下。