Re: ANSI Joins
- From: Sanjay Mishra <mishra.sanjay@xxxxxxxxx>
- To: mgogala@xxxxxxxxxxxxxxxxxxxx
- Date: Tue, 18 Jan 2005 20:46:54 -0600
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@xxxxxxxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
