About this tutorial:
Video duration: 00:03:35
A subquery also known as an inner query, is a query that is contained within the outer query. Subqueries are always written within parenthesis and can contain multiple inner queries, with each inner query enclosed within parenthesis. In this activity 2-1 we will:
Create a new query in design view
Create a subquery using the Criteria row of the ProductID field to retrieve records pertaining to a particular category.
Lastly, we will test the query.