<div>
Brilliant angelIII. &nbsp;Thanks!!!<br />
=)
</div>


<div>
<div class="content wysiwyg-content">
In this query, I am trying to get the top 5 shops in the table based on the products liked to them.<br />
It works well until I try to query the Products table to see if the product is active.<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strsqlPC = &quot;SELECT top 5 shopid,Count(*) as numCount FROM Shop2Products WHERE productid=(SELECT productID from Products WHERE prodActive='Active') GROUP BY shopid ORDER BY Count(*) DESC&quot;<br />
<br />
<br />
What I get is:<br />
Microsoft JET Database Engine error '80004005' <br />
At most one record can be returned by this subquery. <br />
<br />
I am running ASP code which is querying an Access Database.
</div>
</div>


In this query, I am trying to get the top 5 shops in the table based on the products liked to them.
It works well until I try to query the Products table to see if the product is active.

          strsqlPC = "SELECT top 5 shopid,Count(*) as numCount FROM Shop2Products WHERE productid=(SELECT productID from Products WHERE prodActive='Active') GROUP BY shopid ORDER BY Count(*) DESC"


What I get is:
Microsoft JET Database Engine error '80004005' 
At most one record can be returned by this subquery. 

I am running ASP code which is querying an Access Database.

SQL Query help for ASP code

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.