Re: SQL question, SELECT DISTINCT

[leegold]

On Mon, 16 Aug 2004 12:39:32 -0400, SGreen@stripped said:
> Let me see if I can explain it a little better....If you need to move all 
> 3 columns to the new table but you only want *1* row where f2 and f3 have 
> a unique combination of values, how do you want to choose *which* value
> of 
> f1 to move over with that combination? Do you want the minimum value, the 
> maximum value, or no value at all?

Whoa, it's not that complicated....I want to text only f2 && f3 for
uniqueness, not f1 && f2 && f3. That's all. If I'm not making it clear -
don't worry...it's not life or death. Thanks.
...snip...