Skip to Main Content

Oracle Database Discussions

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!

Full Outer Join, vs Cross Join, vs Natural Join vs Union

metalrayNov 10 2010 — edited Nov 12 2010
Hi Guys,
A mate asked me about the different join types and their were a few I was really uncertain about. I did some research and came up with the definitions below but those do not clearly differentiate the four (especially Cross Join and UNION).

Difference between:

1. Full Outer join
"set of all combinations of tuples in R and S that are equal on their common attribute names"

2. Cross Join = Cartesian Product
"A cartesian join is a join of every row of one table to every row of another table"

3. Natural Join
"A natural join is a join statement that compares the common columns of both tables with each other. "

4. Union
"set operation that returns all rows from two different select statements, and then eliminates any duplicate rows from the result set. "
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2010
Added on Nov 10 2010
5 comments
6,678 views