SQL连接两个没有键/关系的表

SELECT A.*, B.*
FROM (
    SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS TempKey
    FROM TableA
) A
JOIN (
    SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS TempKey
    FROM TableB
) B ON A.TempKey = B.TempKey;

SELECT A.*, B.*
FROM (
    SELECT *, RAND() AS RandomNumber
    FROM TableA
) A
JOIN (
    SELECT *, RAND() AS RandomNumber
    FROM TableB
) B ON A.RandomNumber = B.RandomNumber;