Subqueries, or subselect statements, are a way to use a result set as a resource in another query to limit or refine results. The alternative is often multiple queries or unwanted manipulation ...