The alternative is often multiple queries or unwanted manipulation of the raw data. With a subquery, you can reference tables to determine inclusion of data or, in some cases, return a column that ...