There are ways to structure a query that will minimize the complexity while raising confidence in the data returned. This article shares a few techniques that will help simplify the writing of complex queries.

This story continues at http://www.databasejournal.com/featu...ex-Queries.htm