Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.

This story continues at http://www.databasejournal.com/featu...Statements.htm