I haven't been able to find a good SQL forum that get's responses like here on
CF-Talk.
So I'm sorry, skip over this message is it urks you that I posted this. Sorry.
I'm trying to figure out how the average rating (dbo.recipereviews.ratingID)
where the
average is greater than or equal to 4 (recipe_ave >= 4) on a scale from 1-5.
The below
statement isn't working.
Arggghhh! HELP
SELECT *, AVG(dbo.recipereviews.ratingID) AS recipe_ave
FROM dbo.recipes INNER JOIN
dbo.relrecipecats ON dbo.recipes.recipeID =
dbo.relrecipecats.recipeID INNER JOIN
dbo.recipecategories ON
dbo.relrecipecats.recipecategoryID = dbo.recipecategories.recipecategoryID
INNER JOIN
dbo.recipereviews ON dbo.recipes.recipeID =
dbo.recipereviews.recipeID INNER JOIN
dbo.ratings ON dbo.ratings.ratingID =
dbo.recipereviews.ratingID INNER JOIN
dbo.images ON dbo.recipes.imageID = dbo.images.imageID
WHERE (MONTH(dbo.recipes.datecreated) >= MONTH('October 1, 2006')) AND
(dbo.recipes.addressID = 0) AND (dbo.recipes.imageID <> 0) AND
(dbo.recipecategories.recipecategory = 'Breads') AND
(recipe_ave >= 4)
D
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281619
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
