Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select with dual-field empty
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