<snip> > > Here is the query I'd like to run (which fails - but is exactly what I need > > for a query): > > select sum(count(host)) from TABLE_HOST where path_a='' group by host </snip>
well I think this one fails because count only ever returns one number (correct?). So I would think sum would take in a stream of numbers and then add them all together. Thus sum would fail, in my mind anyway. __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
