Query Question...

[Jack Lauman]

Given the following query, how can it be modified to return 'Cuisine'(s) 
that have no rows as having a count of zero and also return a SUM of 
COUNT(*)?

SELECT w.WebsiteName, r.Cuisine, COUNT(*)
FROM Restaurant r
JOIN RestaurantWebsites w
ON r.RestaurantID = w.RestaurantID
WHERE w.WebsiteName = 'TOW'
GROUP BY w.WebsiteName, r.Cuisine
Thanks.

Jack


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]