Read this SQL tutorial to learn ... 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 ...