Subqueries and derived tables can add great versatility to SQL Statements, cut down complexity, but can occsionally be a curse when their effect on performance is poorly understood. Surely everyone understands the various types of subqueries and how they are used? If you felt a tewinge of doubt, here is Rob Sheldon’s easy guide to the subject.