Re: SQL question, SELECT DISTINCT

[SGreen]

It all depends on which values of f1 you want to ignore.

f1      f2     f3
-----   -----  ------
val1-1  val2   val3
val1-2  val2   val3
val1-3  val2   val3

Which value of f1 would you want in your new table? Which ones to ignore? 
Are there other columns (beyond these 3) to move as well?

Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"leegold" <leegold@stripped> wrote on 08/16/2004 11:29:33 AM:

> say I'm selecting distinct (non-duplicate) rows for insertion,
> 
> insert into original_table select distinct * from new_table
> 
> these tables have 3  fields/row. Per the above code all 3 fields are 
> evaluated by "distict *" .
> 
> But my question is: I want to ignore field1, therefore I only want to 
> test if any rows have field2 *and* field3 as dups - that would be my 
> distinct test and then do the insert based on that. Test f2 and f3, not
> f1.
> 
> What the sql? Help is greatly appreciated.
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>