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: <mgillesp_at_uoguelph.ca>
Date: 23 Oct 2006 06:17:48 -0700
Message-ID: <1161609468.724995.259530@i42g2000cwa.googlegroups.com>


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.

Cheers,

Mitch Received on Mon Oct 23 2006 - 08:17:48 CDT

Original text of this message

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