Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> newbie question about join
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
![]() |
![]() |