RE: ::grumble:: SQL Problem (bug?) with HAVING clause?

2001-12-19 Thread Carsten H. Pedersen
> Here's a conundrum I'm having with MySQL. > > The following code returns a bunch of records: > > SELECT sl_Year, >sl_DayOfYear, >sl_Query, >SUM(sl_CountOfOccurrences) AS NumRequests > FROM SearchLog > GROUP BY sl_Year, > sl_DayOfYear, > sl_Query > > o

::grumble:: SQL Problem (bug?) with HAVING clause?

2001-12-19 Thread Kevin-Neil Klop
Here's a conundrum I'm having with MySQL. The following code returns a bunch of records: SELECT sl_Year, sl_DayOfYear, sl_Query, SUM(sl_CountOfOccurrences) AS NumRequests FROM SearchLog GROUP BY sl_Year, sl_DayOfYear, sl_Query one of these records looks li