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 -> newbie question about join

newbie question about join

From: sean nakasone <seannakasone_at_yahoo.com>
Date: Fri, 23 Feb 2007 13:10:45 -1000
Message-ID: <Pine.WNT.4.64.0702231254300.3084@pgsnakason.hawaiianelectric.net>


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); Received on Fri Feb 23 2007 - 17:10:45 CST

Original text of this message

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