Re: ANSI join syntax

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 7 Apr 2005 09:42:58 -0800
Message-ID: <bf463805040710424034a399@mail.gmail.com>

Excellent article Jonathan, thanks for pointing it out. Jared

On Apr 6, 2005 5:42 PM, Jonathan Gennick <jonathan_at_gennick.com> wrote:
>
> Hello Paul,
>
> It *can* make a difference when you move a predicate from the
> WHERE clause into the JOIN clause. (It surprised me too) Have a look
> at the following article:
>
> http://www.oreillynet.com/pub/a/network/2002/10/01/whatsinacondition.html
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 07 2005 - 13:46:56 CDT