On 10/17/06, Ken Naim <kennaim_at_gmail.com> wrote:
>
> I find the ansi syntax verbose and agree with the poster who said that
> while
> it highlights the joins it obfuscates the tables which I find more
> important
> while debugging data issues. I don't understand why we need the ansi
> syntax
> to separate the join and filter conditions, I have been doing it for years
> in the where clause, first the joins then the filter, look at any of my
> queries and it is plain as day even with 20 tables 6 inline views and 4
> sub-queries.
>
as an exercise it might be illuminating to supply one such query to someone
who is competent in sql, but unfamiliar with your work and ask them which
tables are joined to which and how?
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 17 2006 - 13:34:25 CDT
