Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Non-equal Joins
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