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