Joins : Please talk ANSI SQL with me...

People, who had to port a Microsoft SQL Server or Access database over to Oracle, know what I'm talking about. This article show us a good example of ANSI SQL joins and also show us a few good reasons why we should use ANSI join syntax instead of classic and specific join syntax :

1. You don't need to specify the join condition in a natural join;
2. You can do more with ANSI SQL join syntax than with classic Oracle syntax;
3. There is no performance penalty;
4. In the long run you will see more of it, and less of the older syntax;
5. It's portable;
6. It's easier to understand what is happening .

Bottom line is :

So join me in creating portable SQL joins that are easy to read, do more than you can with Oracle syntax, and don't slow you down.