Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Multiple COUNTS, Multiple tables in single query?
syber - 1:04 am on Jul 10, 2006 (gmt 0)
I should have said that each recipes.recipeID could be listed more than once, so that COUNT(DISTINCT recipes.recipeID) would take care of it.
Thread source:: http://www.webmasterworld.com/databases_sql_mysql/615.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com