Re: newbie question about join

sean nakasone 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);

One is ISO syntax the other ANSI. They are both inner joins.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org