On 10/17/06, Ken Naim <kennaim@xxxxxxxxx> 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
