I have the following query which display every Cuisine in the database
sorted by the WebsiteName.
How can I modify this to get a COUNT of the number of records in each
Cuisine in each WebsiteName?
SELECT DISTINCT Restaurant.Cuisine, RestaurantWebsites.WebsiteName
FROM Restaurant
INNER JOIN RestaurantWebsites ON ( Restaurant.RestaurantID =
RestaurantWebsites.RestaurantID )
WHERE RestaurantWebsites.WebsiteName = 'TOS'
ORDER BY Cuisine ASC
LIMIT 0 , 300
Thanks
Jack
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
