Re: ANSI Joins

I hope you will find the article
http://www.oreillynet.com/pub/a/network/2002/04/23/fulljoin.html useful.
Other than being standards compliant, I like the fact that the ANSI join syntax allows you to (1) separate out the join conditions from filter conditions, and (2) perform a full outer join, without resorting to UNION.

Sanjay Mishra

On Tue, 18 Jan 2005 13:45:03 -0500, Mladen Gogala <mgogala_at_allegientsystems.com> wrote:
> My developers are starting to use ANSI joins in vain hope that they will
> make their apps portable
> across databases. I have a positive attitude toward ANSI joins: I hate
> those verbose extensions
> that make SQL statements lengthy and unreadable. What is the opinion of
> other people about ANSI joins?
> What is the @#$%! allure of those things? Where did they learn it from?
> Is there any readable document
> that explains ANSI joins for dummies?
>
> --
> Mladen Gogala
> Oracle DBA
> Ext. 121
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l