Page is a not externally linkable
- Code, Content, and Presentation
---- Multiple COUNTS, Multiple tables in single query?
syber - 12:31 am on Jul 10, 2006 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/615.htm
You have two one-to-many relationships in your joins, so each ratings.ratingID can be represented multiple times.
Try COUNT(DISTINCT ratings.ratingID)
Brought to you by WebmasterWorld: http://www.webmasterworld.com