Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: phranque
My attempt so far has been to break the problem into simpler parts, iterating through the Genre table, then performing another query to see if the number of albums for each Genre is greater than 5. As you can imagine this is painfully slow. Iíve had few attempts but only succeeded in locking up my machine :).
If someone could help with problem it would be appreciated.
For anyone else reading this thread, HAVING essentially lets you do a WHERE clause after the GROUP BY has aggregated your data. So you can limit queries by min(), max(), count(), etc., which WHERE cannot do.
Glad to hear it worked, humpo. :)