I am trying to execute a query that has several sub-queries embedded in it. The funny thing is, as a stand alone query on it's own, the query works fine. It's very quick and has no problem with the having clause. I was wondering if you have either had this problem using aggregate functions with the having clause in a subquery.