没有联接条件的联接表

您可以为每个表指定行号,然后按行号合并:

WITH
Table1WithRowNumber as (
    select row_number() over (order by id) as RowNumber, id from Table1
),

Table2WithRowNumber as (
    select row_number() over (order by id) as RowNumber, id from Table2
)

SELECT Table1WithRowNumber.Id, Table2WithRowNumber.Id as Id2
FROM Table1WithRowNumber 
FULL OUTER JOIN Table2WithRowNumber ON Table1WithRowNumber.RowNumber = Table2WithRowNumber.RowNumber

编辑 :修改为使用完全外部联接,因此可以获得所有行(带空值)。

使用交叉连接

  Select * From tableA Cross Join TableB

但是要明白,对于TableA中的每一行和TableB中的每一行的每一个组合,您将在输出中得到一行。。。

因此,如果表A有8行,表B有4行,您将得到32行数据。。。 如果想要小于这个值,就必须指定一些联接条件,以便从输出中过滤掉多余的行

好吧,这会有用的:

Select A.ID, B.ID From
  (SELECT ROW_NUMBER () OVER (ORDER BY ID) AS RowNumber, ID FROM Tbl2 ) A
full outer join
  (SELECT ROW_NUMBER () OVER (ORDER BY ID) AS RowNumber, ID FROM Tbl1 ) B 
on (A.RowNumber=B.RowNumber)

SQL1交叉连接在这里也适用。

Select * 
From tableA, TableB