I always enjoy writing and reading articles about JOIN Clauses. One of my friend and the best ColdFusion Expert Ben Nadel has written good article about SQL JOINs. There are few interesting comments as well at the end of article.
“JOIN grouping is pretty powerful and can get you out of those sticky situations that involve mixed table relationship rules. ” Ben Nadel – Grouping JOIN Clauses In SQL
Reference : Pinal Dave (http://blog.SQLAuthority.com)