Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL - JOIN using UNION ?? UNION using JOIN ?? with example!

873477Jul 5 2011 — edited Oct 29 2013
I was asked this question during one of my interviews. Can you do JOIN using UNION keyword? Can you do UNION using JOIN keyword?

That is -
1. I should get same output as JOIN without using JOIN keyword, but using UNION Keyword?
2. I should get same output as UNION without using UNION keyword, but using JOIN Keyword?

Can you give me an example of how to do this if possible?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2013
Added on Jul 5 2011
#database, #pl-sql, #query, #sql, #sql-developer
7 comments
10,879 views