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, [EMAIL PROTECTED] 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...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]