Read this SQL tutorial ... in another query to limit or refine results. The alternative is often multiple queries or unwanted manipulation of the raw data. With a subquery, you can reference ...