Re: SQL question, SELECT DISTINCT

[Michael Stassen]

You were perfectly clear.  We understand that you only want to test f2 and 
f3 for uniqueness.  The question is, which of the possible values of f1 do 
you want to get.  Do you see?  For a particular unique f2, f3 combination, 
there may be multiple f1 values.  How should we choose which one to put in 
the new table?  That is what Shawn has asked twice, and you have not 
answered.  Until you answer that, no one can provide a correct solution.

Michael

leegold wrote:

> 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 test 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...
>