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

Home -> Community -> Usenet -> c.d.o.server -> Re: nested identifier

Re: nested identifier

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Sep 2006 19:36:29 +0200
Message-ID: <vvu2h29ncktdjvr6m3atohh3j03kirmfkr@4ax.com>


On 20 Sep 2006 06:30:05 -0700, "tawright915" <tawright915_at_gmail.com> wrote:

>So is it possible to show the results from the inner query? I need to
>see the p_no from the outer query and the p_no from the inner one.
>Will a join allow me to do this? Also if I'm comparing the same table
>to itself...wouldn't I use an exists instead of an outer join?
>
>Thanks
>Tom

As from this post I no longer respond to top-posted contributions.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Sep 20 2006 - 12:36:29 CDT

Original text of this message

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