Dmitry Ruban wrote: > calvin: >> Rex has his point point >> > That would count people who have 2 addresses in either Auckland or >> > Wellington. >> >> This is a problem of using `OR` and `having count` at the same time. >> >> Calvin >> > > COUNT(DISTINCT city) != COUNT(city)
Good point. Any 2 different addresses will be needed. 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] -~----------~----~----~----~------~----~------~--~---
