Two very nice articles on SQL tips for Java developers, or anyone who uses SQL, really:
10 Common Mistakes Java Developers Make When Writing SQL
10 More Common Mistakes Java Developers Make When Writing SQL
In Part 2, one tip is always to use ANSI joins. I tend to agree, but I just want to note that I have run into situations where the "old style" was required by Oracle. Maybe someone can correct me if this doesn't apply anymore, but back about 7 years ago when I really dug into materialized views, I found that query rewrite required the older syntax. Always thought that was a bit odd.