How to join 2 tables without common column in SQL
Content (required): How to join 2 tables without common column in SQL and get the columns from both the tables side by side?
I tried using the CROSS JOIN and UNION which did not fetch the expected result for me.
In CROSS JOIN, the columns from one table will be repeating as it is a cartesian join. I can not use UNION as the data types of columns in these tables are not same. Also the number of columns are not same in these tables.
I also tried using the rownum. But the number of rows in these tables may not be same. So I don't think this would work either.