ctx2002 wrote: > I mean: "COUNT(DISTINCT city) is the condition you wish to apply to > each set". > > I was thought, why "any 2 different addresses will be needed". > > if there are 2 same cities belongs to same person , for example: > > there is a set. > > 1 auckland > 1 auckland > > the COUNT(DISTINCT city) will count that set as one.
Yep, and Dmitry's condition was COUNT(DISTINCT city) = 2 This would return 1 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] -~----------~----~----~----~------~----~------~--~---
