Eddie Awad has an excellent series on the various join syntaxes, demonstrating both in the "old" Oracle syntax as well as the standard ANSI SQL92 syntax. Now you can get your head around inner vs outer joins and all the rest!

I'm going to make an effort to switch to the ANSI syntax for all the reasons that he lists.