ctx2002 wrote: >>> COUNT(DISTINCT city) != COUNT(city) >> Good point. Any 2 different addresses will be needed. > > COUNT(DISTINCT city) is apply to GROUP BY ,
GROUP BY defines how you wish to assemble the set of rows. HAVING is the condition you wish to apply to each set, using set operators. I don't understand "is apply to". Cheers, Rex --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
