Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Select with dual-field empty

Re: Select with dual-field empty

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 23 Oct 2006 06:28:49 -0700
Message-ID: <1161610129.746679.190720@m73g2000cwd.googlegroups.com>

mgill..._at_uoguelph.ca wrote:
> I may be wrong in this instance, but isn't there a problem with the
> original SQL statement because your creating two outer joins on the
> same table ( Table 'b' )? Or does this error not occur because they're
> different fields.

It's perfectly legitimate, as a single outer join based on multiple columns.
FYI - you could also have ...
where a.code1=b.code1(+)

   and a.code2=b.code2
which represent a different business requirement. hth Received on Mon Oct 23 2006 - 08:28:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US