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: Theory of joins

Re: Theory of joins

From: <mgogala_at_yahoo.com>
Date: Wed, 27 Jan 1999 20:32:49 GMT
Message-ID: <78nt5g$jm6$1@nnrp1.dejanews.com>


In article <78npqm$gep$1_at_nnrp1.dejanews.com>,   Fernando Sánchez <nandros_at_my-dejanews.com> wrote:
> Hello,
>
> I'd like to know what is called a semi-join. Not an Oracle-specific question.
>
> Thanks
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Semi-join (at least, it's my understanding) is synonymous with non equi -join, or join between two tables where the joining relationship isn't based on equality operator.
For another possible explanation of semi-join, see the impeachment process in the U.S. Senate.
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 27 1999 - 14:32:49 CST

Original text of this message

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