tibberous Posted July 5, 2008 Share Posted July 5, 2008 I have two tables, products and ratings. Products have ratings, but the products table doesn't store the number of ratings. To find the number of ratings for a particular product, you just do a "select count(*) from ratings where Owner='productID'". How can I have this added on to all my products in a query? I was thinking something like... select *, (select count(*) from `ratings` where Owner=`products`.id) as numberOfRatings from `ratings`, `products` That gives an error though =/ Any ideas? Quote Link to comment Share on other sites More sharing options...
tibberous Posted July 5, 2008 Author Share Posted July 5, 2008 I got it. You only select from the products table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.