You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reporting and Analytics for HCM

How to join 2 tables without common column in SQL

Summary:


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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!