On 11/1/06, coldfusion. developer @ att. net coldfusion. developer @ att. net > > From the 2nd query, I'm trying to extract only records where the average of > avg(ratingvalue) >=4 and I'm not sure how do do this.
> 2nd Query > SELECT count(recipereviewID) AS totalratings, avg(ratingvalue) AS > avgrating > FROM recipereviews INNER JOIN ratings ON recipereviews.ratingID = > ratings.ratingID > WHERE recipeID = #whatscookin.recipeID# Try adding this: HAVING avg(ratingvalue) >= 4 -- Ken -- -- Kenneth S. Redler [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2601 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
