Avoid Nested Sub-Queries

Nested sub-queries can adversely affect the efficiency of a query and frustrate maintenance efforts.