"Roy Hann" <specially@[EMAIL PROTECTED]
> wrote:
>"Ed Prochak" <edprochak@[EMAIL PROTECTED]
> wrote in message
>news:4b1507c9-207e-4555-bd27-42dd0e84de9d@[EMAIL PROTECTED]
>> On Jun 26, 12:31 pm, "David Cressey" <cresse...@[EMAIL PROTECTED]
> wrote:
>
>> When I see
>> SELECT DISTINCT
>> in anything but an ad hoc query, I know something is wrong with the
>> query.
>
>Eh?! How can you possibly "know"any such thing? Projecting away
>distingui****ng columns is perfectly respectable, desirable and necessary.
Why is it necessary?
[snip]
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.


|