SQL Server 2008
Two tables:
Table A has following data:
RowA
RowB
RowC
RowD
Table B has following data:
Row4
Row3
Row2
Row1
I want to get the following output:
RowA Row1
RowB Row2
RowC Row3
RowD Row4
The only common value between the two tables is the row number
I can get the data individually of course:
SELECT val
FROM A
ORDER BY val
SELECT val
FROM B
ORDER BY val
But how do I join on the row number?
And what if I don't have an order-by, but just want the rows in the order they come out?
RowA Row4
RowB Row3
RowC Row2
RowD Row1
as in the join of
SELECT val
FROM A
SELECT val
FROM B
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…