SQL(简单)逐行连接两个表

Question

我想逐行加入 2 个表，这意味着如果我有两个表 A，B 我想要: A 的第 1 行仅加入 B 的第 1 行 A 的第 2 行仅加入 B 的第 2 行等

如果我有

table A
name

John
George
Nick
Legolas



table B
surname

Smith
Rogueman
Born
Yohazol


the result would be:

table C
name    surname


John    Smith
George  Rogueman
Nick    Born
Legolas Yohazol

提前致谢

Answer 1

像这样的..

SELECT *
FROM (
  SELECT row_number() OVER (), *
  FROM tbl1
  -- ORDER BY id (or whatever you're ordering by)
) AS t1
INNER JOIN (
  SELECT row_number() OVER (), *
  FROM tbl2
  -- ORDER BY id (or whatever you're ordering by)
) AS t2
  USING (row_number);