Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie question about join

Re: newbie question about join

From: Thorsten Kettner <thorsten.kettner_at_web.de>
Date: 26 Feb 2007 01:47:39 -0800
Message-ID: <1172483259.673834.39630@j27g2000cwj.googlegroups.com>


On 24 Feb., 00:10, sean nakasone <seannakas..._at_yahoo.com> wrote:
> I'm a little bit confused, are these two select statements synonymous?
> The second one has a 'join...on', while the first one does not.
>
> select t.* from user_tab_cols t, user_all_tables a
> where t.table_name = a.table_name;
>
> select t.* from user_tab_cols t join user_all_tables a
> on (t.table_Name = a.table_name);

Yes they are identical. I recommend using the second notation, because when it comes to joining more tables your statement will be much more readable as you state each table's join conditions next it instead of having them placed somewhere in a huge where clause. Received on Mon Feb 26 2007 - 03:47:39 CST

Original text of this message

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