Sorry... I was having a brain fart. (I use entries in the web.xml file
to generate a dropdown list of cuisines). The field cuisine is part of
the restaurant table. And it does not accept a null value. It should
be split out into it's own table.
I do need to get a SUM of all the values returned by COUNT(*) though.
Here's an example of the results for the query below:
WebsiteName Cuisine COUNT(*)
TOS Afghan 1
TOS African 1
TOS American 64
TOS Argentinean 1
TOS Asian 9
TOS BBQ 7
The SUM of COUNT(*) in this case would be '83'
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
