Monday, January 4, 2021

how join two tables using sql without a common column

SELECT t1.Column1, t1.Column2, t2.Column3, t2.Column4 FROM ( SELECT Column1, Column2, ROW_NUMBER() OVER (ORDER BY Column1) AS rn FROM Table1) AS t1 FULL OUTER JOIN ( SELECT Column3, Column4, ROW_NUMBER() OVER (ORDER BY Column3) AS rn FROM Table2) AS t2 ON t1.rn = t2.rn --https://stackoverflow.com/questions/32081224/how-join-two-tables-using-sql-without-a-common-column