Re: Oracle interprets ANSI Inner Join as an Outer Join?
Date: Wed, 23 Sep 2009 22:48:54 +0300
LEFT JOIN is the same LEFT [OUTER] JOIN, just simply outer keyword ommited. There is only one inner join, not left or right inner joins.
I have written an article about join types here
Unfortunately the site is down just now, I've already contacted
provider, but one can access this article for example from google
2009/9/23 Charles Schultz <sacrophyte_at_gmail.com>:
> Good day, list,
> Not sure if this is an Oracle bug or a feature; under OSEE 10.2.0.2 on RHEL4
> I have an ANSI "LEFT JOIN" that Oracle is turning into an OUTER JOIN. Any
> idea why? I am having a hard time getting the optimizer to force a INNER
> join without changing the query (stinking db-agnostic vendors *grin*).
> NOTE: I do not know ANSI SQL all that well, but from what I have read, INNER
> joins are implied unless OUTER joins are explicitly stated.