Re: Outer Join with an extra condition
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 10 Jun 2008 04:01:47 -0700 (PDT)
Message-ID: <3029b491-1012-41c2-94f3-22327ddc06b2@y38g2000hsy.googlegroups.com>
Date: Tue, 10 Jun 2008 04:01:47 -0700 (PDT)
Message-ID: <3029b491-1012-41c2-94f3-22327ddc06b2@y38g2000hsy.googlegroups.com>
On Jun 7, 7:20 am, "dn.p..._at_gmail.com" <dn.p..._at_gmail.com> wrote:
> The trick is to get the 'placement' of that clause (and column_name is
> not null) correct, and simple as it seems to me now, I didn't get it
> right at once.
There is also a nice blog entry about the various forms of OUTER JOIN:
http://optimizermagic.blogspot.com/2007/12/outerjoins-in-oracle.html
Cheers
robert Received on Tue Jun 10 2008 - 06:01:47 CDT