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