[phpug] Re: Database - select question.

[ctx2002]

On Dec 15, 4:01 pm, Rex Johnston <spammeatyourpe...@sclnz.com> wrote:
> 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.

   COUNT(DISTINCT city) is apply to GROUP BY ,
   why any 2 different addresses will be needed?

   regards,
>
> Rex
--~--~---------~--~----~------------~-------~--~----~
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to nzphpug@googlegroups.com
To unsubscribe, send email to
nzphpug+unsubscr...@googlegroups.com
-~----------~----~----~----~------~----~------~--~---