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: Non-equal Joins

Re: Non-equal Joins

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: 2000/07/21
Message-ID: <3978BCA6.6BB99BC5@0800-einwahl.de>#1/1

Hi John,

You are right. The only way to avoid that a cartesian product has to be considered is an equi-join.

Martin

John Jones wrote:
>
> I seem to remember somewhere in the dark recesses of my brain that a
> NON-equal join would cause a cartasian product. Can any one confirm this or
> is old age setting in. Please respond to john.jones_at_duke.edu if possbile.
> Don't always get a chance to read news groups. Thanks.
>
> --
> John Jones
> Senior Oracle DBA
> Duke University OIT
> john.jones_at_duke.edu
Received on Fri Jul 21 2000 - 00:00:00 CDT

Original text of this message

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