Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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.
Tagged:
0