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: can u explain a self join statement in SQL?

Re: can u explain a self join statement in SQL?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 26 Oct 2005 08:02:10 -0700
Message-ID: <1130337897.289308.14100@g14g2000cwa.googlegroups.com>


Pull the SQL manual for the version of Oracle that you are using. Oracle explains what a self-join is there and includes at least one example.

"A self join is a join of a table to itself. This table appears twice in the FROM clause and is followed by ..."

But your text should have an example.

HTH -- Mark D Powell -- Received on Wed Oct 26 2005 - 10:02:10 CDT

Original text of this message

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