Re: Best way to use INNER JOIN?

From: radino <rgolian_at_gmail.com>
Date: Tue, 3 Jun 2008 01:03:48 -0700 (PDT)
Message-ID: <35433b7d-94f6-4529-bdb1-b5348c2a93de@s50g2000hsb.googlegroups.com>


ad 3)
Ask Tom:
"Natural joins -- a bug waiting to happen.", "I strongly, vehemently strongly, discourage the use of this feature called natural joins.",
"To join tables by their column names -- how patently just a bad idea",
"Never never never use this feature."

On Jun 1, 6:58 pm, "harry" <a..._at_abc.com> wrote:
> Using Oracle 10g
>
> I've always used this form of inner joins -
>
> 1. select BOOKSHELF.Title from BOOKSHELF, BOOK_ORDER where
> BOOKSHELF.Title = BOOK_ORDER.Title;
>
> A colleague tells me that I should be using this form (but can't tell me
> why?) -
>
> 2. select Title from BOOKSHELF inner join BOOK_ORDER using (Title);
>
> There is another way I've seen (but don't like) -
>
> 3. select Title from BOOKSHELF natural inner join BOOK_ORDER;
>
> So, is there any difference between methods 1 and 2? if not is it safe to
> continue using method 1 then?
>
> thanks in advance
>
> harry
Received on Tue Jun 03 2008 - 03:03:48 CDT

Original text of this message