title: Creating a subquery in Access
body: <p>I am attempting to create a subquery in Access but I am receiving an error stating that one record can be returned by this subquery. I am wanting to find the top 10 companies that have the most pets then I want to know the name of those pets. I have never created a subquery before so I am not sure where I am going wrong. Here is what I have: </p>
  
  <pre><code>SELECT TOP 10 dbo_tGovenrnmentRegulatoryAgency.GovernmentRegulatoryAgency
  (SELECT dbo_tPet.Pet
  FROM dbo_tPet)
  
  FROM dbo_tPet INNER JOIN dbo_tGovenrnmentRegulatoryAgency ON
  dbo_tPet.GovernmentRegulatoryAgencyID =
  dbo_tGovenrnmentRegulatoryAgency.GovernmentRegulatoryAgencyID
  GROUP BY dbo_tGovenrnmentRegulatoryAgency.GovernmentRegulatoryAgency
  ORDER BY Count(dbo_tPet.PetID) DESC;
  </code></pre>