We've expanded our news coverage and improved our search! Visit news.oreilly.com for the latest or search for all things across O'Reilly!
advertisement

Article:
  SQL Subqueries
Subject:   Sub Queries
Date:   2004-01-27 11:31:22
From:   leenmary
Hi,
I'm working with Oracle as part of an ASP project and need to add a query. I have this query working within Access but am not sure how to transfer it to the correct syntax for oracle. Here's the Access Query:


SELECT CAnd.Name, Count(VotetoC.No2) AS CountOfNo2
FROM CAnd INNER JOIN VotetoC ON CAnd.Cand_ID = VotetoC.Can_ID
GROUP BY CAnd.Name
HAVING (((Count(VotetoC.No2))=True));


I keep getting the error for the last line. I need to count only the rows where VotetoC.No2 has a value of True.


Thank you in advance!