Count (Distinct ?

SQL Server 2000
Why can't I do this:
Count (Distinct FName, LName)
?
TIA,
OwenWhat are you trying to do? COUNT returns a single value. So if you have 15
distinct first names and 18 distinct last names, what result do you expect
from your query?
"Owen Mortensen" <ojm.NO_SPAM@.acm.org> wrote in message
news:uPaNUYHRGHA.2436@.TK2MSFTNGP11.phx.gbl...
> SQL Server 2000
> Why can't I do this:
> Count (Distinct FName, LName)
> ?
> TIA,
> Owen
>