...and so help me God.
[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
An inner join only returns the first row. A full outer join returns all nine combinations of the three rows
I'd have avoided giving that impression had I know it myself.Originally posted by Avi Abrami:
Since Oracle 9i, Oracle SQL does support the ANSI syntax -- using "inner join", "outer join", etc. I believe it would be better not to give the impression that Oracle still uses a proprietary syntax for "outer join"s.
Originally posted by Avi Abrami:
Jeanne,
And a left outer join would return ...?
And a right outer join would return ...?
[For the sake of completeness, please.]
[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
...and so help me God.
Originally posted by Michael Matola:
If I understand the above data correctly, I think it's a confusing example to introduce joins for data that contains duplicates and nulls.
[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
"How many licks ..." - I think all of this dog's research starts with these words. Tasty tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
|